Loading

Thursday, October 1, 2009

MS SQL Backup Database to Disk

To create a full database backup using Transact-SQL

Execute the BACKUP DATABASE statement to create the full database backup, specifying:
  1. The name of the database to back up.
  2. The backup device where the full database backup is written.
Example
BACKUP DATABASE AdventureWorks 
TO DISK = 'C:\Backups\AdventureWorks.BAK'


No comments:

Post a Comment