Points for SQL Backup

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'
WITH FORMAT
GO