how to schedule backup in sql server 2008?

sql-server-2008 backup schedule database-backups
nectar picture nectar · Jul 5, 2010 · Viewed 52.3k times · Source

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

Answer

Ralf de Kleine picture Ralf de Kleine · Jul 5, 2010

  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.

Mantenance Plans

Related questions

How to restore to a different database in sql server?

I have a backup of Database1 from a week ago. The backup is done weekly in the scheduler and I get a .bak file. Now I want to fiddle with some data so I need to restore it to a …

Read More
Cannot open backup device. Operating System error 5

Below is the query that I am using to backup (create a .bak) my database. However, whenever I run it, I always get this error message: Msg 3201, Level 16, State 1, Line 1 Cannot open backup device 'C:\Users\Me\Desktop\Backup\MyDB.…

Read More
Opening a SQL Server .bak file (Not restoring!)

I have been reading a LOT of google posts and StackOverflow questions about how to restore a database in SQL Server from a .bak file. But none of them states how to just READ the tables in the database-backup. (None …

Read More