Hi
I am new to SQL Server 2005 and I want to back up my database on a daily basis.I want that every day at 2:00 pm an automatic backup(a full back up) to be stored in C:\backups
Any help
Printable View
Hi
I am new to SQL Server 2005 and I want to back up my database on a daily basis.I want that every day at 2:00 pm an automatic backup(a full back up) to be stored in C:\backups
Any help
It's actually very easy.
In Management Studio, open the Management branch of the explorer tree.
Then open the Maintenance Plan Tab.
Right click and select New Maintenance Plan.
Give it a name and it'll open up pane where you can drag various tasks on.
Simply drag a Backup Database Task onto the plan and define it (the setting are pretty self explanatory) and Bob's your relative of choice.