---

Search posts under SQL Server:

---

Backup of database in SQL Server

How to take backup of the database in SQL Server?

To take back up of the database in SQL Server, right click the database and select Taks > Back Up…

This shows the Back Up Database dialog box as shown below. Now click on Add.. button to add the Destination folder and file name where we want to take the backup of the database.

Click OK that starts the backup and creates a .bak file at the selected location (generally backup file extension is .bak).