Making a Backup of MS SQL Database With Query
If we want to back up a database with the query method in MS SQL Server, the following path is followed.
BACKUP DATABASE {Database Name} TO DISK = {Path of .bak File to Backup}An example of its use would be as follows..
BACKUP DATABASE OurDB TO DISK='c:\OurDB.bak'