Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Classic ASP versions(v3.4.XX)
 replacing deleted catagories
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

HP
Starting Member

9 Posts

Posted - 18 September 2002 :  22:22:48  Show Profile
When I went to delete a thread, I accidentaly deleted a whole section of almost 100 threads. I have a backup from yesterday of the whole database, is there a way to do a partial restore of just the section of treads or do I have to restore the whole board to yeaterdays backup?

bax
Junior Member

141 Posts

Posted - 18 September 2002 :  23:16:42  Show Profile
Ouch. One thing you could try - restore the database as something different - Forum_2 or something like that (I'm assuming SQL). Then, you could write a query to move the data from this database to the other. Depends how much traffic, how much loss you have if it is worth it.

One other suggestion - create backlogs to handle events like this. I've created a way so that when you delete stuff (again, with SQL Server only), it logs all of the deletions to a set of backlog tables. Makes the database quite a bit larger, yes, but protects from situations like this. By logging all deletions, I can just go to the backlog and restore from there, without having to go thru this. If you want input on this, email me.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 1.28 seconds. Powered By: Snitz Forums 2000 Version 3.4.07