windows vps hosting

To restore your MS SQL Server database, please follow these simple steps:-

1) Log into your Windows Hosting UK 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. 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) Click Connect.

5) Expand the server name and expand Databases.

6) Right-click your database, expand Tasks, expand Restore and select Database.

7) Under Source for restore, select From Device and click the … box.

Select File and click Add.

9) Select the backup file you wish to restore.

10) Click OK.

11) Check the backup set to restore.

12) Click OK to begin the restore.