How to Take a Backup of Database in SSMS

How to Backup a Database in SSMS
 

1 Run SQL Server Management Studio from the Start Menu

In Windows 2012, click the start icon at the left down corner, then choose SQL Server Management Studio.

2 Backup the Database

2.1 Connect to the Server

2.2 Choose the Database

2.3 Right-click on the database name “test” and click “Tasks”, and then click “Back Up”

2.4 Remove the existing path to backup folder

A

2.5 Add the new path to your desired backup folder

2.5.1 Click “add”

2.5.2 Select the  Backup Destination

2.5.3 Locate the Database Files.

2.5.4 Click “OK”

2.6 A Screen that Verifies that the Backup is Successful Appears

 

3 Done

 
 

Add Feedback