Making a Backup of MS SQL Database With Query

36 Reads Ms Sql

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'
Ms Sql

You May Interest

Getting List of All Views in MS SQL Database

Using CASE WHEN in MS SQL

Using MS SQL WHERE

What are Isolation Levels in SQL Server ?

MS SQL Getting List of All Column Names of a Table