SQL Server Job backup

Steps for automatic backup in SQL Server 2005 database: 1. Open SQL Server Management Studio 2. Start the SQL Server proxy 3. Click job> create job. 4. Enter the job name in "regular" 5. 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) 6. Add a plan and set the frequency and time. OK.