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.