how to schedule backup in sql server 2008? [closed]

Question

how can I schedule daily backup at 9:00pm in SQL server 2008?

Answer 1

1. Use Microsoft SQL Server Management Studio to create a new Maintenance Plan.

2. In the object explorer go to the folder Management > Maintenance Plans.

3. This will open the designer.

4. In the Toolbox you will find a task named Back Up Database Task, drag this onto the designer.

5. Right click 'Back Up Database Task' select edit from the context menu

6. Backup type:

   • Full: Does a full backup each time (ref)
   • Differential: Makes a backup of the changes between last and current state. You will need all differentials + initial backup if you want to restore! (ref)
   • Transaction Log: Makes a backup of the transactions since last full backup. (ref)

7. Right click the task to select the databases to backup.

Change the schedule of your maintenance plan to set when it will run.