Hi,
I have one SQL server where my databases where kept on the D drive, and
the transaction logs where on a physically seperate C drive. The D
drive became corrupted and I could not start SQL Server because the
master database was corrupt. So, I had to use the RebuildDM.exe to
rebuild the system tables. I have the log files sitting on the C
drive, but I never had a chance to back them up to the most recent
point today because I could not get into SQL Server until I rebuild it.
Now what I would like to do is just restore the databases and then use
the logs that are sitting on C, but the only way it seems that I can do
this is by backing up the transaction logs first, which I did not have
a chance to do. Is there anyway I can take a backup of my DB and tell
it to use the transaction logs that already exists so that it can apply
any missing transactions?I forgot to mention, this box is windows server 2003 with sql server
2000 SP4|||Doh, after hours of searching I found the answer right after posting
this. For anyone who has this problem, look here
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q253817
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment