Set SQL Server timed automatic Database Backup

First, start the Database "SQL Server proxy". There are two startup methods: 1. Enable the SQL Server Agent in the SQL Server 2005 service by using the SQL database-Configuration tool-SQL servers Configuration Manager. 2. Right-click my computer-Manage-services and applicationsProgram-- Service, find the SQL Server Agent and enable it.
Start the SQL Server proxy
 
Click job> create job
"
Enter the job name in general.

Create step, type select T-SQL, enter the following statement in the following command

Declare @ strpath nvarchar (200)

Set @ strpath = convert (nvarchar (19), getdate (), 120)

Set @ strpath = Replace (@ strpath ,':','.')

Set @ strpath = 'd: \ Bak \ '+ 'databasename' + @ strpath +'. Bak'
Backup database [databasename] to disk = @ strpath with noinit, nounload, noskip, stats = 10, noformat
(Change D: \ Bak \ To your backup path, and change databasename to the name of the database you want to back up) Add a plan, set the frequency, time, and so on.
OK.