SQL 2008 R2 - MASTER.LDF corrupted without backup - Can I start SQL without MASTER LOG ?

Hello,

I have a SQL server that has a corrupt MASTER.LDF file, which prevents SQL services from starting at all.

Is there any way to start SQL services with just MASTER.MDF?  So far I have tried renaming MASTER.LDF to MASTER.LDF.OLD and SQL reports that the file is missing and still does not start (although I do not get a corrupt message).

If I cannot start MASTER.MDF without the log file, is there a way to rebuild the log file?

Help is appreciated.  Thanks!
LVL 5
jkeegan123Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
jkeegan123Connect With a Mentor Author Commented:
@Vitor Montalvao:  Nope, my customer did not have a backup of ANY database.  
@ ScottPletcher:  I tried that, and the service still did not start.

What we ended up doing to resolve was:  

1.  File copy backup all databases.
2.  Using the SETUP DVD of SQL 2008 R2 Standard to rebuild all of the system databases (master, model, temp, etc...).  After this was done, the service started again, but all of the permissions were gone from MASTER.  
3.  Using the corrupted version of MASTER, I was able to mount the file without an LDF and look at the members in the file.  I exported these, re-created them in the new MASTER, and re-assigned the permissions down to the database levels by ....restarting the service.  

No more orphans!
0
 
Scott PletcherSenior DBACommented:
Keep an original copy of the existing master.mdf before any attempts were made to restart.  Keep that as a base master to go back to as you try to recover.

Right now, what I can think to try is:
1) Recreate a brand new master db from scratch, as if the instance were just installed.  
2) Shut down SQL.
3) Copy the original master.mdf over the recreated .mdf (but naturally don't touch the log file).
4) See if SQL can start up with the old master and the new, fresh .ldf.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Don't you have a backup of the master database?
0
 
jkeegan123Author Commented:
No other solution resolved the issue.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.