Points for SQL Backups

Points for SQL Backup

  • BackupPath MUST be located on the same drive letter as where SQL Server was installed.
  • Backup function MUST be performed from the PC that has SQL Server installed.

Below is the SQL Script used to perform the SQL Backup.  Please substitute the variables DB_Database, BackupPath, and Filename with your settings and test the script with Enterprise Manager:

BACKUP DATABASE DB_Database TO DISK = ‘BackupPath\filename.bak’