AdventureWorks2012 name database

Sql Server Backup Query

A sql server backup query is a statement or set of statements used to back up a sql server database. The backup query can be used to back up the entire database, or specific tables or data within the database.

The basic syntax for a sql server backup query is:

BACKUP DATABASE TO 

This command will back up the specified database to the specified backup device. The backup device can be a local or network drive, or a tape drive.…