So I was cleaning up some spam by posters and managed to delete a thread of 7 pages. Just wondering if there is anyway of recovering the thread. My backup is a few days old and I don't want to go back that far in time, if I don't have to.
Stats SQL 2000 modded snitz 3.4.04 I have access to the SQL server, if it helps me... Any help would be great or just put me out of my misery.
If I do have to revert to the backup of the database, can I just "copy and paste" the thread from the backup to the production database?
The longer answer is that if you can restore your backup to another location and pull only those records that make the thread (you can use TOPIC_ID in the tables), then insert THOSE records into your current database.
It's not as simple as copying, cause you probably would have changes of Ids. If you could restore the database with some other name, then you could possibly create a query to retrieve the topic in question and another to retrieve its replies. For each query, you could use DTS to import the data from the backup DB to the live DB, making sure that you configure DTS to preserver identity values.
Sorry I didn't get back and let you know what has happened. I learned that I forgot to include the SQL data base when I built this server and consequently I lost the info. thankfully this valuable lesson on checking your backups periodically was not huge loss. I was able to recover most of what was posted in the thread using the trick of work offline. I think I lost only one page in the end and now the back up is doing the data base as well. Live and learn. Thanks for your help guys.
Topic Locked
Posted - 05 March 2006 : 04:35:54
