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 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...!!!
