Today i came through a problem where in i have to take Back up of the SQL server database .
It is a simple query :
BACKUP DATABASE TestDB TO DISK='D:\MyDatabase.bak' with FORMAT
Where
"TESTDB" => Your Database Name
"D:\" => Any local Hard Drive C,D,E,F or any;
"MyDataBase" => Any name by which you want to take Back up.
Thanks,
Nitin Sharma
