Restoring a database to its default state

[Joseph Jun]

A common request that we receive in the Technical Support department is to remove all database objects, and that can sometimes result in a major delay for what would seem to be a very simple procedure. I've attached a blank database that will allow you to restore your database to its default state and is compatible for SQL Server 2000, 2005 and 2008.

Just perform the following steps:

1. First and foremost, create a backup of your current database as this procedure will remove ALL present database objects. Use the Create A Backup utility to make a backup of your current database:

• SQL Server 2008
• SQL Server 2005
• SQL Server 2000

2. Download the attached dasp_cleandb.zip file and extract the dasp_cleandb.bak file.

3. Upload the backup file to the FTP server for your account.

4. Access the appropriate version of the Restore From Backup utility for your database:

• SQL Server 2008
• SQL Server 2005
• SQL Server 2000

5. If you have more than one database on a single database platform, make sure that you select the correct database from the drop-down menu or else you will lose all data for the wrong database.

6. Click on the "Browse Web Server for BAK" button, locate the dasp_cleandb.bak file and click on the "Select" button.

7. Now, just click on the "Restore Backup" button to invoke the restoration procedure.

Once the database restore has finished, you'll have a clean database.

[wisemx]

Excellent! This will be very useful.