How to backup an MSSQL Server 2005 Database ?

Rock · #1 (**permalink**) 25-03-2008, 08:39

The following article explains on backing up an MSSQL Server 2005 database using MSSQL Server Management Studio Express.

Microsoft SQL Server Management Studio Express (SSMSE) is a free, easy-to-use graphical management tool for managing SQL Server 2005 Express Edition and SQL Server 2005 Express Edition with Advanced Services. The backup can then be used at a later date to restore the database if any information is lost or in case the database goes corrupt.
The backup file needs to have a .BAK file extension.

Note: If your database is stored on our shared server, then the backup file will be created on the server itself and not on your local machine.
If you need a copy of the backup file, please contact our windows support and they can provide you a copy of the backup file.

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

1. Open MSSQL Server Management Studio. [If you don't have one, download here]

2. Connect to your MS SQL Server database using the DB username & password.

3. Right-click your database, expand All Tasks and select Back Up. [as shown in the following image..]

4. Under Back Up type, select Full. [as shown in the following image..]

5. Under Destination, click Add. [as shown in the following image]

6. Enter the path and file name for the backup file. [as shown in the following image]

7. Click OK & review the settings for the backup.

The instructions above will create a complete backup of your database into the desired folder. This is a recommended method to ensure that all data is backed up properly.
Please let us know if you encounter any problems while connecting to the server or during the backup operation, we'll fix it quickly.