How to backup of MS SQL Server database for Windows VPS?


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

1) First log into your windows dedicated server through Remote Desktop Connection.

2) Click Start, Programs, Microsoft SQL Server 2005 and select SQL Server Management Studio Express or SQL Server Management Studio. After that click Start, Programs, Microsoft SQL Server 2005 and select SQL Server Management Studio.

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

4) Now click Connect.

5) Expand the server name and expand Databases.

6) Now right-click your database, expand Tasks and select Back Up.

7) select Full under Backup type .

8 ) Click Add under Destination .

9) Enter the path and file name for the backup file.

10) Click OK.

11) Review the settings for the backup.

12) Click OK to begin the backup.

Note:The steps above will create a complete backup of your database.

Leave a Reply

Your email address will not be published. Required fields are marked *