Automatic backup of a Database in SQL EXPRESS 2005
If you want to automate a backup of a database in SQL Server Express, there is a simple solution using a .bat. file.
Create a new text file. This file should contain the following information:
SET J=%date:~-10,2%
SET A=%date:~-4%
SET M=%date:~-7,2%
SET H=%time:~0,2%
SET MN=%time:~3,2%
SET S=%time:~-5,2%
IF "%time:~0,1%"==" " SET H=0%HOURS:~1,1%
SET DIRECTORY=E:\Directory_name\
FILE=%DIRECTORY%\name _of_backupfile_%J%_%M%_%A%_A_%H%_%MN%_%S%.bak
IF NOT exist "%DIRECTORY%" md "%DIRECTORY%"
cd C:\Program Files\Microsoft SQL Server\90\Tools\Binn
sqlcmd -S Server_name\SQLEXPRESS -Q "BACKUP DATABASE Name_of_sql_database TO DISK = N'%FILE%' WITH INIT, NAME = N'Automatic back up of database', STATS = 1"
Finally, change the extension.
Txt. Bat
- The E:\Directory_name\ is the location where you want to save your backup .bat file.
- The name _of_backupfile is the name of the .bat file
- Finally, the Name_of_sql_database is the name of the database.
- In addition, it displays the date and time of backup name assigned to the .bat file.
- Then just create a scheduled task.
Arcserver 12.5 sql express 2005