How to create MSSQL DB Back Up?


I want to create a backup file as MyDB.BAK and save it in somewhere using MSSQL Management server , but as you all know, MSSQLSMS saves the .BAK file in side the server drive. How can I make a backup?


You can do this from our portal at

Follow this guide


Thanks Robert, It worked.


How to Restore a Sql Server Backup?


To restore follow this guide: