Updated on Kisan Patel
This tutorial will explain you how to take a backup of a database or create a backup file (.bak) of your database, using SQL Server Management Studio Express.
To take back up of the database in SQL Server, right click the database and select Tasks => 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).