Skip to main content

How to Restore a Microsoft SQL Server Database in Windows Control Panel

You can restore a Microsoft SQL Server database using the Windows Control Panel (WCP) to recover data from a previous point in time. This process is available to Account Users on Hostek plans that include Microsoft SQL Server support.

You can restore a Microsoft SQL Server database using the Windows Control Panel (WCP) to recover data from a previous point in time. This process is available to Account Users on Hostek plans that include Microsoft SQL Server support.

Important: This procedure requires a valid backup of the specific Microsoft SQL Server database. The restoration will overwrite the existing data in the target database.

Before you begin

You will need:

  • An active Windows Control Panel (WCP) account.

  • A Hostek hosting plan that includes Microsoft SQL Server.

  • A valid backup file of the database you wish to restore.

Restore the Microsoft SQL Server database

  1. Log in to the Windows Control Panel.

  2. Navigate to Databases > Microsoft SQL Server.

  3. Select the specific database you wish to restore.

  4. Click the Restore button.

  5. Select the backup file from the available options.

  6. Enter the date and time for the desired restore point.

  7. Click Restore.

Confirm the result

Once the restoration process is complete, you can verify the success of the operation:

  • The status indicator in the Windows Control Panel will show as "Active" or "Success."

  • You can connect to the database using a management tool like SQL Server Management Studio (SSMS) to verify that the data matches the expected state.

Limitations

This procedure only restores the database content; it does not restore the database's configuration settings or user permissions. If you need to restore a database that is not currently listed in your Windows Control Panel, contact Hostek support to verify your account's database allocations.

Did this answer your question?