MS SQL Database backup using SQL Command

Use the following SQL command in order to generate the back-up of the MS SQL database.


BACKUP DATABASE Database_Name TO DISK 'Location_For_Backup'

For example, generate back-up of database SampleDB, we can use the following database;

BACKUP DATABASE SampleDB TO DISK 'D:\SampleDB.BAK' 

Happy Querying...!!!