Web Wiz Forums - need help restoring a deleted thread

Print Page | Close Window

need help restoring a deleted thread

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=24371
Printed Date: 06 April 2026 at 5:24pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: need help restoring a deleted thread

Posted By: iSec
Subject: need help restoring a deleted thread
Date Posted: 09 September 2007 at 2:30am

MS SQL Server database,
I have a backup of the database that was done last night...
One moderator mistakenly deleted one of the most popular topics on my forum, and its her own topic..(fortunately)

I created a test database and imported the backup that was done last night on that test db... now I need to know how to get that one topic moved from the test database to the actual database.

The deleted thread is still in the backup, is there any query that I can run to get this back or is this impossible to accomplish?

-------------
"When it gets dark enough, you can see the stars"
-Charles A. Beard

Replies:

Posted By: dj air
Date Posted: 09 September 2007 at 11:52am

this is possiable.

you need to

1. create a conection to both DB's
2. get the topic details from the topic table loaded into a array or an open connection
3. get the topic threads from the threads table with the Topic_ID of above Topic
4. use the insert SQL command to copy all aspects of the topic (topic table details) of that ID into a new topic into the latest/live DB.
5. requery the latest DB to get the new topic ID thats been created in the topic table.
6. use that ID and insert the posts/threads from the old threads table into the new Database threads table using the topic ID value as the ID that was collected/created in step 5.

im not sure if the post cout is changed when deleted or not.; but that will get the topic back into the live Database. Its not an easy job but you can/could use Enterprise manager or SQL Express manager studio