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
 General SQL Server Forums
 New to SQL Server Administration
 Can start SQL Services

Author  Topic 

tek0011
Starting Member

2 Posts

Posted - 2013-03-19 : 18:24:42
So I am having issues starting my SQL services. Currently it is failing the start due to:

quote:
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

chadmat
The Chadinator

1974 Posts

Posted - 2013-03-19 : 18:40:37
Try starting in minimal configuration mode, then fix the problem.

-Chad
Go to Top of Page

tek0011
Starting Member

2 Posts

Posted - 2013-03-20 : 11:34:49
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

prett
Posting Yak Master

212 Posts

Posted - 2013-03-21 : 05:36:38
Please check this post: http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/3028169b-0270-4eac-99d3-a0807d5b1c3b

Hope it will help you to resolve you issue!!
Go to Top of Page
   

- Advertisement -