SQL BACKUP with Query

We can use the SQL query to take backup from SQL server.

Use the below query to do that.

Syntax:

BACKUP DATABASE <Database Name> TO DISK = '<Destination path Here>' 

Sample:

BACKUP DATABASE MYDATABASE TO DISK = 'D:\MYDATABASE.BAK'

Posted in: DOT NET