Category: Backup Database

MS SQL Backup Database to Disk

Posted in Backup Database, Linux, Microsoft, Query Analyzer, SQL, Transact-SQL, Utility, WindowsLeave a Comment on 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: The name of the database to back up. The backup device where the full database backup is written. Example BACKUP DATABASE AdventureWorks TO DISK = ‘C:BackupsAdventureWorks.BAK’

MS SQL Backup Database to Disk Read More
Posted on By user