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.
