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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

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

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Can start SQL Services
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

2 Posts

Posted - 03/19/2013 :  18:24:42  Show Profile  Reply with Quote
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

Edited by - tek0011 on 03/19/2013 18:27:27

The Chadinator

1974 Posts

Posted - 03/19/2013 :  18:40:37  Show Profile  Visit chadmat's Homepage  Reply with Quote
Try starting in minimal configuration mode, then fix the problem.

Go to Top of Page

Starting Member

2 Posts

Posted - 03/20/2013 :  11:34:49  Show Profile  Reply with Quote
Yea cant seem to get that to work either. By no means am I a SQL dba. Merely forced to be a jack of all trades.

sqlcmd -s localhost -u sa -p password -m ?

Is there a way to do this in the gui?
Go to Top of Page

Posting Yak Master

212 Posts

Posted - 03/21/2013 :  05:36:38  Show Profile  Visit prett's Homepage  Reply with Quote
Please check this post:

Hope it will help you to resolve you issue!!
Go to Top of Page
  Previous Topic Topic Next 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.05 seconds. Powered By: Snitz Forums 2000