Corrupt SQL2000 DB with no backup for several days. Can the DB be restored
up using latest backup, and then the log file used to bring it back to say
midnight last night?
Anybody know if this is possible, and how?

Thanks
S

[quoted text, click to view]

If your database is in full recovery mode, then it should be possible - see
"Recovering to a Point In Time" and "How to restore to a point in time" in
Books Online. Essentially, you would back up your log now, then restore the
full backup with NORECOVERY, then the log backup(s) with STOPAT and
RECOVERY.

This assumes that when you say 'corrupt' you mean the data has been trashed
(eg someone dropped a table). If you mean that the .mdf file is physically
corrupt and the database is completely unusable, then see the section on
"Recovering in the event of media failure" in Books Online, under "Full
Recovery".

But if your database is in simple reovery mode, then there probably isn't
much you can do, as the log is being continually overwritten.

Simon

[quoted text, click to view]

Yes, but I'd recommend calling Microsoft if it's really important to you.

And make a backup of all files before beginning.


[quoted text, click to view]