2011 Jan IDTECK. © All rights reserved
39
7) How can I have a backup database automatically with arranged schedule?
This function is not supported when using
Microsoft SQL Server 2005 Express Edition
.
SQL Server Agent is needed for automatic maintenance function when using Microsoft SQL Server 2005
Solution
Step 1)
Run Microsoft SQL 2005 Management Studio
log in with ID and Password.
Step 1)
On Object Explorer, Select Management and
click right button
>> Maintenance Plans Wizard.