Restoring a SQL Server database to its default (clean) state

Discussion in 'Databases' started by rum, Jan 20, 2011.

  1. rum

    rum Winhost Staff

    Before you restore your database to its defaults, please back it up as all current data in it will be deleted. Please see this KB article for the instructions on how to backup Winhost databases.

    The easiest way to reset your SQL Server database on Winhost servers to its default state is to delete it an create it again in your Winhost control panel as shown in the instructions below:

    • Login to your Winhost Control Panel at https://cp.Winhost.com
    • In the navigation menu under Winhost logo click on "Sites" tab
    • In "Your Sites" section click "Manage" link next to a site your database belongs to
    • In the "Site Tools" section click on "MS SQL 2008" button
    • Click on the "Delete" link next to the database you'd like to delete
    • Click "OK" button in the pop-up message dialog if you'd like to proceed deleting your database
    • Click on "Add" button
    • In the "Database Name" text field enter the name of your database
    • In the "Quota" text field enter the quota in megabites. Quota must be a minimum of 25MB and cannot be more than the available free quota
    • Click "Create" button
     
    Last edited by a moderator: Oct 14, 2015

Share This Page