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’