February 2, 2011 at 4:31 am
I have an active/passive 2005 cluster which crashed, due to a disk issue. Now when the sql server comes up it fails with the tempdb resource looking for a drive that never existed. The correct tempdb files are on a drive set which is available. Is there a way to bring things up and tell the sql server where tempdb is
February 2, 2011 at 4:56 am
- Are you sure it is using the correct files for master db ?
It is very strange your tempdb drive has never been there for sqlserver.
How would it have used it in the past;
One option could be someone altered the tempdb path and didn't restart the sqlserver instance.
Double check all your drives are online !
If your double checks still confirm you need to alter the tempdb location
follow the procedure described in this MS doc:
"Moving System Databases" http://msdn.microsoft.com/en-us/library/ms345408%28v=SQL.90%29.aspx
Also double check your service account has the needed windows authority to get to the new file locations !
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 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply