February 12, 2010 at 8:47 am
Hi all,
I am having problems starting SQL Services, the error I received in the Events Viewer is:
initerrlog: Could not open error log file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG'. Operating system error = 3(failed to retrieve text for this error. Reason: 15105).
(The path is fine and the older ERRORLOGS are still there)
My startup parameters are:
-dC:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
(This is all installed onto my laptop and using my account - administrator)
I have checked all the permissions to access the folders mentioned above - which are fine (full access)
I am not sure what to to do next?
Many Thanks in advance
February 12, 2010 at 3:49 pm
Assuming all permissions are OK, I'd suspect anti-virus here as the file exists...and the OS says it doesn't...
Also have you tried the reboot & repair combo?
February 12, 2010 at 4:06 pm
Yep, all permissions were fine.
I tried everything...
I ran the repair on SQL Server 2008 and find out it is not reading the master.mdf and mastlog.ldf.
I then decided to restore at a point when it was working.
Now all is fine (touch wood)
Cheers
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply