Admin-Ahead Community

Windows => General Windows => Topic started by: rohitj on November 30, 2013, 02:28:50 pm

Title: MSSQL database Backup
Post by: rohitj 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.