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.
| 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 |
 |
|
|
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? |
|
|
|
prett
Posting Yak Master
212 Posts |
|
|
|
|
|
Can start SQL Services