Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Can't Start - could not open file mastlog.ldf

Author  Topic 

denis_the_thief
Aged Yak Warrior

596 Posts

Posted - 2013-01-31 : 17:20:04
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
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-02-01 : 13:04:12
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

596 Posts

Posted - 2013-02-01 : 13:31:56
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 - 2013-02-04 : 05:56:12
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
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-02-05 : 04:47:09
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

596 Posts

Posted - 2013-02-05 : 10:52:56
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
   

- Advertisement -