Knowledgebase
(28)Applications (16)DNS (23)Domains (9)Downloads (61)eMail (5)File Transfer Protocol (144)Flash Tutorials (18)General (11)IIS (4)Migrations (30)MSSQL Server (10)MySQL Server (74)Plesk Panel (2)Security and Hack (9)SEO (3)Server Settings (10)Services (3)SSL Certificates (9)Your Account
SEARCH
Knowledgebase
How do I backup my MS SQL Server 2005/2008 database using Management Studio?
Posted by on 22 August 2012 08:16 AM

The following article explains how to backup your MS SQL Server 2005/2008/2008 R2 database using Micsrosoft SQL Server Management Studio. The backup can then be used at a later date to restore the database if information is lost. The backup file needs to have a .bak file extension.

To backup your MS SQL Server database, please follow these steps:

  1. Open SQL Server Management Studio.
  2. Connect to your MS SQL Server database.
  3. Right-click your database, expand All Tasks and select Back Up.
  4. Under Backup type, select Full.
  5. Under Destination, click Add.
  6. Enter the path and file name for the backup file.
  7. Click OK.
  8. Review the settings for the backup.
  9. Click OK to begin the backup.

The instructions above will create a complete backup of your database. This is the recommended method to ensure that all data is backed up.

(1 vote(s))
Helpful
Not helpful
Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).