SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Can't Start - could not open file mastlog.ldf
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

denis_the_thief
Aged Yak Warrior

Canada
591 Posts

Posted - 01/31/2013 :  17:20:04  Show Profile  Reply with Quote
We are not able to start our SQL Server. We needed to do a Server Reboot and have had no luck since. We get this message: could not open file mastlog.ldf

We have tried the following:
- verified mastlog.ldf exists
- verified permissions on mastlog.ldf
- verified start-up parameters
- we were able to attach this Master Database on another server under another Database name suggesting it is not currupt

Some of our Domain settings changed recently. But we believe the Server startup is under the correct account.

Does anyone have any ideas?

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2004 Posts

Posted - 02/01/2013 :  13:04:12  Show Profile  Visit jackv's Homepage  Reply with Quote
I had a similar problem recently - and it related to the SQL Server Service Account being taken out of the correct Domain Group.
In this case we weren't using Local System for start up account , but an AD authenticated account

As an experiment - could you add the Service account to the Administrator group and check if this works.

Are you seeing any messages in the Event Viewer error logs? If so , what are they?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

denis_the_thief
Aged Yak Warrior

Canada
591 Posts

Posted - 02/01/2013 :  13:31:56  Show Profile  Reply with Quote
Thankyou.

This is the message we are finding in the event viewer: FCB::Open failed
C:\MSSQL\MSSQL10.GLOBDEV\MSSQL\DATA\mastlog.ldf

I am not sure what you mean by the SQL Service account. But the Log on as in the SQL Server configuration Manager is: NT Authority\Network Service.

Go to Top of Page

srimami
Posting Yak Master

160 Posts

Posted - 02/04/2013 :  05:56:12  Show Profile  Reply with Quote
Have you checked whether this ldf file exists under the specified location; copy C:\MSSQL\MSSQL10.GLOBDEV\MSSQL\DATA\ to windows explorer and check whether mastlog.ldf exists or not.
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2004 Posts

Posted - 02/05/2013 :  04:47:09  Show Profile  Visit jackv's Homepage  Reply with Quote
If it does exist , then the error message is probably due to the account the SQL Server service runs under doesn't have sufficient permissions to the folder containing the log files. Check the security on the folder for the account accessing the file



Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

denis_the_thief
Aged Yak Warrior

Canada
591 Posts

Posted - 02/05/2013 :  10:52:56  Show Profile  Reply with Quote
Thanks. The files do exist (and in the right place). And we set the permissions on the 2 Master Database files to Everyone can read/write.

Just making sure I understand. Is the SQL Server Service Account meaning what you put in the Servive is the Log On as?
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000