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

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

tek0011
Starting Member

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

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

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

chadmat
The Chadinator

USA
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.

-Chad
Go to Top of Page

tek0011
Starting Member

USA
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

prett
Posting Yak Master

USA
195 Posts

Posted - 03/21/2013 :  05:36:38  Show Profile  Visit prett's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New 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.06 seconds. Powered By: Snitz Forums 2000