Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

So I am having issues starting my SQL services. Currently it is failing the start due to:

FileMgr::StartLogFiles: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\modellog.ldf'. Diagnose and correct the operating system error, and retry the operation.

The issue herein lies in the fact that this .ldf file is not on the E drive. There is no E: drive. The file is located on the F: drive.

I cannot find anywhere to tell SQL to change this. I can not drop/move/detach/etc the databases, because I cant even get the service to start, in order to connect.

This is happening on 3 different instances of SQL, after volume moves. Any ideas?

SQL 2008

share|improve this question
    
Are there any messages in the error log pertaining to the master database? –  Mike Fal Mar 19 '13 at 22:47

1 Answer 1

Go to Command Prompt and Try Start Service With This

NET START MSSQLServer /f /T3608

Then in Command Prompt Login With SQLcMD

SQLCMD -E  -S ServerName

Then run Following Command to move the model log to the F drive. Make sure the path is correct.

ALTER DATABASE Model MODIFY FILE( NAME = modellog , FILENAME = 'F:Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\modellog.ldf' )
Go

Then stop and re-start your instance.

Repeat with other files if needed. Except master. That is a whole different problem.

share|improve this answer
    
or try SQLCMD -A to use the DAC since this would be in single user mode. –  swasheck Mar 19 '13 at 23:07
    
remember, you should use NET STOP to stop the instance instead of the configuration mgr if you use NET START –  Cougar9000 May 21 '13 at 22:51

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.