Monday 25 December 2017

Database Backup in Sql Server.

In this article, We will discuss How to take backup of a Database in Sql Server.

First of all, Login into your SQL Server Management Studio.

Select the particular database which you want to take backup -> After that right click on it -> Goto Tasks -> Goto Backup -> Click on it.

After that a new Screen Will appear and which looks like as below figure,


After that Press Ok.

After few Seconds/Minutes, the backup will be Completed and it will show you in popup.

After that goto that particular location where you saved you backup file and you can see the .bak file.

0 comments:

Post a Comment