Subscribe For Free Updates!

We'll not spam mate! We promise.

May 23, 2012

How to Make Back and Restore Data base

Views:

How to Make Back and Restore Data base
To day I show You how To

HOW TO MAKE DATA BASE BACKUP AND HOW TO RESTORE IT IN SQL SERVER Management Studio.

Normally Data back can be Done very easily but there is some Confusion in restoring the data base.
In previous post I show you how to connect Manage studio with Visual studio .

Following Step is Involve to take Back up of data base

First, you need to configure the Microsoft SQL Server Management Studio on your local machine. If you don’t have it, you can download it from the following location.



Step 1: Open your Microsoft SQL Server Management Studio, whichever you prefer, standard or express edition.
Step 2: Using your Database Username and Password, simply login to your MS SQL server database.
Step 3: Select the database >> Right-click >> Tasks >> Back Up [as shown in the image below]:
Backup MS SQL Server 2008 Database
Once you click on the “Backup” the following Backup Database window will appear [as shown in the image below]:
Backup MS SQL Server 2008 Database Folow Step 2
Step 4: Select the following options:
  1. Backup type: Full
  2. Under Destination, Backup to: Disk
Step 5: Now, by clicking on the “Add” button the following window will appear to select the path and file name for the database backup file [as shown in the image below]:
Backup MS SQL Server 2008 Database - Select Backup Destination
Step 6: Select the destination folder for the backup file and enter the “File name” with .bak extension [as shown in the image below]:
Backup MS SQL Server 2008 Database - Locate A Database Files

Make sure you place your MS SQL database .bak file under the MSSQL backup folder.
Step 7: Hit the OK button to finish the backup of your MS SQL Server 2008 Database. Upon the successful completion of database backup, the following confirmation window will appear with a message “The backup of database “yourdatabasename” completed successfully. [as shown in the image below]:
Backup MS SQL Server 2008 Database - Confirmation Screen
Following the above shown steps, you will be able to create a successful backup of your MS SQL Server 2008 Database into the desired folder.
How to Restore MS SQL Server 2008 Database Backup File ?
In order to restore a database from a backup file, follow the steps shown below:
Step 1: Open your Microsoft SQL Server Management Studio Express and connect to your database.
Step 2: Select the database >> Right-click >> Tasks >> Restore >> Database [as shown in the image below]:
Restore MS SQL Server 2008 Database
Step 3:  The following “Restore Database“ windows will appear. Select “From device” mentioned under the “Source for restore” and click the button infront of that to specify the file location [as shown in the image below]:
Restore MS SQL Server 2008 Database - Step 2
Step 4: Select the option “Backup media as File” and click on the Add button to add the backup file location [as shown in the image below]:
Restore MS SQL Server 2008 Database - Specify Backup
Step 5: Select the backup file you wish to restore and Hit the OK button [as shown in the image below]:
Restore MS SQL Server 2008 Database Locate The Backup File
That’s it! You will get the confirmation windows with a message “The restoration of database “yourdatabasename” completed successfully.” Now you know the procedure of backing up and restoring MS SQL Server 2008 Database.

VIDEO




Plese Feel Free to Socializer This Post
SOCIALIZE IT →
FOLLOW US →
SHARE IT →

0 comments:

Post a Comment

Become a Fan

visual studio learn