Web Wiz Support and Community Forums : Restore a single topic? https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 04 Apr 2026 02:16:45 +0000 Mon, 28 Jan 2008 05:58:44 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=25218 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Restore a single topic? : In the normal addition of records...]]> https://forums.webwiz.net/restore-a-single-topic_topic25218_post131086.html#131086 Author: Nick-V
Subject: 25218
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.]]> Mon, 28 Jan 2008 05:58:44 +0000 https://forums.webwiz.net/restore-a-single-topic_topic25218_post131086.html#131086 <![CDATA[Restore a single topic? : Btw, Nick - Thanks for your help...]]> https://forums.webwiz.net/restore-a-single-topic_topic25218_post131085.html#131085 Author: RadioActiveLamb
Subject: 25218
Posted: 28 January 2008 at 5:51am

Btw, Nick - Thanks for your help Thumbs%20Up]]> Mon, 28 Jan 2008 05:51:49 +0000 https://forums.webwiz.net/restore-a-single-topic_topic25218_post131085.html#131085 <![CDATA[Restore a single topic? : That&#039;s a good idea. However,...]]> https://forums.webwiz.net/restore-a-single-topic_topic25218_post131084.html#131084 Author: RadioActiveLamb
Subject: 25218
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.
]]> Mon, 28 Jan 2008 05:50:56 +0000 https://forums.webwiz.net/restore-a-single-topic_topic25218_post131084.html#131084 <![CDATA[Restore a single topic? : If you can set up a topic record...]]> https://forums.webwiz.net/restore-a-single-topic_topic25218_post131083.html#131083 Author: Nick-V
Subject: 25218
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.
]]> Mon, 28 Jan 2008 05:44:28 +0000 https://forums.webwiz.net/restore-a-single-topic_topic25218_post131083.html#131083 <![CDATA[Restore a single topic? : MadDog wrote:use the backup...]]> https://forums.webwiz.net/restore-a-single-topic_topic25218_post131082.html#131082 Author: RadioActiveLamb
Subject: 25218
Posted: 28 January 2008 at 5:33am

Originally posted by MadDog MadDog wrote:

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.
 
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 Tongue
 
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?
]]> Mon, 28 Jan 2008 05:33:11 +0000 https://forums.webwiz.net/restore-a-single-topic_topic25218_post131082.html#131082 <![CDATA[Restore a single topic? : I suspect you could link MS Access...]]> https://forums.webwiz.net/restore-a-single-topic_topic25218_post131081.html#131081 Author: Nick-V
Subject: 25218
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.]]> Mon, 28 Jan 2008 05:21:30 +0000 https://forums.webwiz.net/restore-a-single-topic_topic25218_post131081.html#131081 <![CDATA[Restore a single topic? : There is no way to restore it...]]> https://forums.webwiz.net/restore-a-single-topic_topic25218_post131080.html#131080 Author: MadDog
Subject: 25218
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.
]]> Mon, 28 Jan 2008 05:18:49 +0000 https://forums.webwiz.net/restore-a-single-topic_topic25218_post131080.html#131080 <![CDATA[Restore a single topic? : One of my other admins accidentally...]]> https://forums.webwiz.net/restore-a-single-topic_topic25218_post131078.html#131078 Author: RadioActiveLamb
Subject: 25218
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.
]]> Mon, 28 Jan 2008 04:38:30 +0000 https://forums.webwiz.net/restore-a-single-topic_topic25218_post131078.html#131078