January 18, 2009 at 1:29 pm
Hi
In my sql server i configured a scheduled restart of sql services at 8 pm.To day I faced a problem that sql server not started.I got the message from error log that "CREATE FILE encountered operating system error 32(The process cannot access the file because it is being used by another process.) while attempting to open or create the physical file ..\...\tempdb.mdf"
I tried to start it manually then it is working fine.
Kindly help me for the root cause
January 18, 2009 at 1:56 pm
It is a bad practise to restart sqlserver instances if not explicitly needed !
(all cached objects will need physical IO to get cached again (your apps will notice !), all in memory counters and statistics will need to be rebuild (by the system), ...
Why are you doing this on a scheduled basis (we have sqlservers up and running for more than 2 years (sql2000 sp4) !)
Depending on the command you issue, your startup can fail if it did not wait long enough for your stop command to finish.
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 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply