https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 06 Apr 2026 15:48:08 +0000 Sun, 09 Sep 2007 11:52:34 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=24371 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/need-help-restoring-a-deleted-thread_topic24371_post127422.html#127422 Author: dj air
Subject: 24371
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
]]> Sun, 09 Sep 2007 11:52:34 +0000 https://forums.webwiz.net/need-help-restoring-a-deleted-thread_topic24371_post127422.html#127422 https://forums.webwiz.net/need-help-restoring-a-deleted-thread_topic24371_post127415.html#127415 Author: iSec
Subject: 24371
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)

Icreated a test database and imported the backup that was done last night on that test db... now I needto know how to get that one topic moved from the test database to theactual 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? 

Edited by Info_Tech - 09 September 2007 at 2:37am]]> Sun, 09 Sep 2007 02:30:05 +0000 https://forums.webwiz.net/need-help-restoring-a-deleted-thread_topic24371_post127415.html#127415