June 24, 2008 at 12:07 am
one of transactional log file deleted can i take t back
June 24, 2008 at 12:14 am
Gone as in deleted from the operating system? how did that happen?
Do you have a recent backup?
How many log files did the database have?
Was the database detached cleanly from SQL?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2008 at 7:21 am
Gail
Sorry, this is not related to the question in the forum.
I see that you have the credentials MCITP.
Would you mind if I ask you a few questions about the
credentials
My e-mail is moderage_waas@ihacares.com
By the way, sorry to have jumped in to ask a
question that was not related.
-------
No to answer the question:
1. Check the recycle bin to see whether the file is present.
2. If not there are third party tools that can recover deleted
data from the hard drive. I am not a good expert at this.
Our networking folks use a OS by the name "KNOPPIX" adn they
are able to go and recover a deleted file.
1. Here are the steps:
1. Stop the server. Do not allow any more writes.
2. Hand over the server to a IT tech guy and ask him to
recover the file.
Good luck!
June 24, 2008 at 7:26 am
MW (6/24/2008)
Would you mind if I ask you a few questions about thecredentials
Please post your questions in the certification forum.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2008 at 7:36 am
you can detach and reattach without a log file and it will make a new one. instructions are in BOL
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply