Automatic Backups of ArcSDE on SQL Server Express

Discussion created by lygismav on Jul 2, 2014
Latest reply on Jul 11, 2014 by STompsett-esristaff

I would like to try to create a script so I can automatically backup my ArcSDE data that is stored on SQL Server Express.  I am using ArcGIS for Server Workgroup Standard v 10.2.2.  My SQL Server is MSSQL Server Express 2008 R2 which is shipped with ArcGIS 10.2.  I have create a backup sql and batch script on the server, however when I try to restore the database using ArcGIS Catalog then ArcCatalog crashes.

The batch file looks like this:
"C:\Program Files\Microsoft SQL Server\100\Tools\Binn\SQLCMD.EXE" -i"C:\SQLBackupScripts\LQPMonday.sql" -S "localhost\sqlexpress"

The SQL file looks like this:
BACKUP DATABASE [ParcelsLQP] TO  DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Backup\LQPParcelsMonday.bak' WITH NOFORMAT, NOINIT,  NAME = N'ParcelsLQP-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10

The backup appears to run and it creates a backup file in about four seconds.  The file size is about twice as large compared to when I create a backup using ArcCatalog-->Database-->Administration-->Backup.

Is there a way to automate backups for SQL Server Express?