Get your server issues fixed by our experts for a price starting at just 25 USD/Hour. Click here to register and open a ticket with us now!

Author Topic: MSSQL database Backup  (Read 2219 times)

0 Members and 1 Guest are viewing this topic.

rohitj

  • Guest
MSSQL database Backup
« on: November 30, 2013, 02:28:50 pm »
Backing up MSSQL database


Please follow the steps below in order to create a .sql backup of your MSSQL database.

1) Log into your server through Remote Desktop Connection.

2) Click Start, Programs, Microsoft SQL Server 2008 and select  SQL Server Management Studio.

3) Enter the requested information:
            Server Type: select Database Engine
        Server Name: this field should be populated by default
        Authentication: select Windows Authentication


4) Click Connect.
5) Expand the server name and expand Databases.
6) Right-click your database, expand Tasks and select Back Up.
7) Under Backup type, select Full.
8. Under Destination, click Add.
9) Enter the path and file name for the backup file.
10) Click OK.
Review the settings for the backup.
Click OK to begin the backup.