60

Backup a database

In SQL Server, you can create a backup of a database very easily.

Create a Backup

Open Microsoft SQL Server Management Studio. You will see Server Object. (See below image)

When you click on the server object you will see Backup device. Right click on the Backup device. You will see an image as follow:

After clicking on “Backup a Database” you will get the following page:

Select the database for which you want to create a backup and then click on the “ok” button. Here we create a backup for database “tutoraspire”.

A new pop-up box will be appeared showing that the backup of the database completed successfully.