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'


You May Interest

What are the System Data Collection Sets Predefined Inside SQL Se ...

Showing Server Active Server Name in MS SQL

What is Extensible Key Management in SQL Server ?

What is Failover Clustering in SQL Server ?

What is Auditing Inside SQL Server ?