Restore a single topic?
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=25218
Printed Date: 04 April 2026 at 2:13am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Restore a single topic?
Posted By: RadioActiveLamb
Subject: Restore a single topic?
Date Posted: 28 January 2008 at 4:38am
|
One of my other admins accidentally deleted a topic. One that was about 30 pages long and ran for three years. It is very important information. This data was deleted three days ago.
Is it possible to restore a single thread? The back-end is MS SQL Express 2005. I have some backups, but I'm unsure how to restore the ONE thread.
Any help is greatly appreciated.
|
Replies:
Posted By: MadDog
Date Posted: 28 January 2008 at 5:18am
|
There is no way to restore it unless you really know MSSQL. Long story short, you have to use the backup database, find the topic you want, find the threads from the topic, create SQL code for each record, go to the current database, and run the SQL code to insert all the missing information. ------------- http://www.iportalx.net" rel="nofollow"> 
|
Posted By: Nick-V
Date Posted: 28 January 2008 at 5:21am
| I suspect you could link MS Access to the two databases and copy the relevant topic and its threads between them. |
Posted By: RadioActiveLamb
Date Posted: 28 January 2008 at 5:33am
I'm certainly no SQL expert. I maintain them in the way of backups, routine maintenance and optimization. I've never dealt with the data itself. I have programmers for that
 I think I understand what you're saying though. However, I start with the "Topic" record, but I'm not able to edit the Topic_ID, being a key field. Any clues there?
|
MadDog wrote:Posted By: Nick-V
Date Posted: 28 January 2008 at 5:44am
|
If you can set up a topic record and the auto-generated ID is different then simply import the relevant thread records with the topicID field changed to whatever it is in the receiving database. If you do this you'll need to look at the email-notify table too.
|
Posted By: RadioActiveLamb
Date Posted: 28 January 2008 at 5:50am
|
That's a good idea. However, before I proceed, I'd like to maintain the same topic number if possible. They aren't re-used, and there are a lot of links to various posts within the topic. I think I'll also run into a problem restoring threads, since the "Thread_ID" is also a read-only field.
It wouldn't be an issue to take the forum down while restoring the data, if that's the reason I can't edit the index fields.
|
Posted By: RadioActiveLamb
Date Posted: 28 January 2008 at 5:51am
Btw, Nick - Thanks for your help 
|
Posted By: Nick-V
Date Posted: 28 January 2008 at 5:58am
| In the normal addition of records the ID is auto-created. There is some way to over-ride this for imports but I can't remember how - check DTS packages. Its not about bringing the database down. A new ID doesn't matter if you change the child records. |