Javatpoint Logo
Javatpoint Logo

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)

SQL Backup a database 1

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:

SQL Backup a database 2

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

SQL Backup a database 3

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 "javatpoint".

SQL Backup a database 4

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



Next TopicRestore a Database




Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA