October 6, 2009 at 7:11 am
I attempted to move the model and msdb databases and now the engine won't start.
Is there a way to start with just the Master DB so I can troubleshoot?
October 6, 2009 at 7:17 am
What method did you use to move the msdb and model databases?
I don't know of a way to start with just master.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
October 6, 2009 at 7:27 am
http://msdn.microsoft.com/en-us/library/ms345408.aspx
I used these commands to modify where the files exist (model and msdb data and log files)
ALTER DATABASE database_name MODIFY FILE( NAME = logical_name , FILENAME = 'new_path\os_file_name' )
and then I physically moved the files.
The instance will not start.
When it tries to start the model DB I get this:
FCB::Open: Operating system error 5(Access is denied.) occurred while creating or opening file 'E:\MSSQL\OVOPS\Datafiles'. Diagnose and correct the operating system error, and retry the operation.
I think I gave the modeldata.mdf the filename datafiles by mistake.
is there a way to start without model?
October 6, 2009 at 7:53 am
You need to provide access authority to the new file location(s) to your sqlserver instance service account !
For startup parameters of SQLServer, check out Books Online topic "Starting and Restarting Services"
local bol ref: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/de8bbb09-9aca-4bfc-8e8d-b05e01f1432a.htm
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply