thanks; I am getting a backup done first, only 3GB, so that will take a while. then I'll try the recovery tool.
Bob
At 04:57 PM 3/23/2005 -0600, you wrote:
There is a master recovery tool: rebuildm.exe in the Binn directory. Run it from command line.
It should rebuild the master log file for you. If not, there is a manual way also, but it is more involved.
Also, be sure to backup everything to a different volume first.
Jacob
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, March 23, 2005 4:36 PM To: [email protected] Subject: OT: MSSQL 7 Emergency
All,
Having a 5 alarm fire: My master log file (ldf) has gotten corrupted and now the SQL Server will not restart leaving a ton of databases unaccessable.
I guess that I have to reinstall... correct ???
Will this not delete any databases that are present?
Precautions, Hints, Etc. Appreciated.
Bob Coalter InterNet Partners
-- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.4 - Release Date: 3/18/2005
---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
-- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.4 - Release Date: 3/18/2005
-- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.4 - Release Date: 3/18/2005
----------------------------------------------------------
To post, send email to [email protected]
To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
