SQL Server 2005 Database automatic Backup Setup method

SQL Server 2005 Database Tutorial Automatic Backup Setup method

Specific steps to implement automatic backups in a SQL Server 2005 database:
In the toolbox on the left (if not, press ctrl+alt+x), drag the Backup database task to the yellow area in the middle

Double-click the dragged out of this task, the design properties will appear in the window

In the database, select the database you want to back up, and then set up the backup to there, and set the file name of the backup

Once you've designed it, click OK, and you can also click T-SQL to see what kind of statements you're going to use to deal with your needs.

Click the "..." after "schedule". button to set the time schedule for execution.

The last to save it.

Detailed Operation instance
1. Open SQL Server Management Studio

2. Start SQL Server Agent

3. Click Job-> New Job

4, "General" Enter the name of the job

5, the new step, the type of T-SQL, in the following command to enter the following statement (red part to be based on their own actual changes, d:sql2005back to their own backup path, Sq_test modified to the name of the database to be backed up)

DECLARE @strPath NVARCHAR (200)

Set @strPath = Convert (NVARCHAR), GETDATE (), 120)

Set @strPath = REPLACE (@strPath, ': ', '. ')

Set @strPath = ' D:sql2005back ' + @strPath + '. Bak '

BACKUP DATABASE [sq_test] to DISK = @strPath with Noinit, Nounload, noskip, STATS = ten, Noformat

6, add the plan, set the frequency, time and so on.

OK, finish.