how can I schedule daily backup at 9:00pm in SQL server 2008?
A:
Create a maintenance plan. SQL 2008 has a great wizard for this in SSMS which will create a SQL Agent job that you can then inspect and modify - and see the SQL syntax for future reference.
Suggestion: create a backup device first.
pelazem
2010-07-05 13:58:12
A:
Use Microsoft SQL Server Management Studio to create a new Maintenance Plan (folder Management > Maintenance Plans).
This will open the designer. In the Toolbox you will find a task named Back Up Database Task, drag this onto the designer.
Right click the task to select the databases to backup.
Change the schedule of your maintenance plan to set when it will run.
rdkleine
2010-07-05 13:58:19
A:
Setup a Maintenance Plan using the Management tree within the SQL Server Studio:
Turnkey
2010-07-05 13:59:42
+1
A:
There's a nice script here http://ola.hallengren.com/ which when run creates some sql agents jobs that perform some of the maintenance tasks you should be doing on a database.
SPE109
2010-07-05 19:15:30
A:
I have schedlued my db backup daily, but i want to set retention policy as Delete the older backup folder older than 3 days.how to do it
Dhiva
2010-08-24 10:07:19
-1 This is not an answer.
Martin Smith
2010-08-24 10:14:41