Before you proceeding you must realize you can potentially destroy your entire database by execution of this SQL Script. We will not be responsible for your use of it. Please do not modify the script as the results can be unwanted.
Use at your own risk!
You have been warned.
Take Application Offline
You must first make sure to take the Application (website) offline before the SQL script can run. If the Application or Proxy is running then it can lock the SQL data and the script will not run.
Backup Your Database!
Please do this Prior to proceeding!
Delete Upload Folder
Since you are performing a complete database reset, it is proper to delete two folders in the Application folder. These are:
- Upload
- SQL_Temp
SQL Script Execution
Now that you have taken the Application offline and more importantly...backed up your database, it is time to proceed with the SQL Script.
THIS SCRIPT WILL RESET YOUR ENTIRE DATABASE. ALL DATA WILL BE GONE!
- After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree.
- Expand Databases, and select the proper application database.
- Click the 'New Query' button (ctrl-n)
- Paste in the text
- Press the 'Execute' button (F5)
The SQL Script will now run and perform the operations requested within the script.
Put Application Back Online
Now that all operations are performed you can now put the Application back online.