The following tutorial explains you the backing up and restoration of your MS SQL Server 2008 Database using the Microsoft SQL Server Management Studio.
Microsoft SQL Server Management Studio Express (SSMSE)
which is an free open source graphical management tool which can be
used to manage your SQL Server 2008 Express Edition. You can use these
backups later if a disaster strikes. It is always better to backup your
database, because you never know if the information is lost or the
database goes corrupt.
The backup file you download will need
to be in .bak file extension. Database stored on the shared servers, the
backups will be generated on the server itself. If you wish to have a
copy of your server backup, then you may need to contact the windows
support team.
In order to backup your MS SQL Server 2008 Database on your windows dedicated server hosting platform, follow the steps shown below:
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.
http://www.microsoft.com/downloads/en/details.aspx?familyid=6053C6F8-82C8-479C-B25B-9ACA13141C9E&displaylang=en
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]:
Once you click on the “Backup” the following Backup Database window will appear [as shown in the image below]:
Step 4: Select the following options:
- Backup type: Full
- 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]:
Step 6: Select the destination folder for the backup file and enter the “File name” with .bak extension [as shown in the image below]:
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]:
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]:
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]:
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]:
Step 5: Select the backup file you wish to restore and Hit the OK button [as shown in the image below]:
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.