karend211 34657 (4/28/2014)
Why would you need a new server just because sql server won't start??
I am thinking worst case scenario & want to be prepared & have a plan for all avenues. Yes, I'd check the windows event log & sql server error log but honestly, unless there is something in there that gives me something to go on, I would be tempted to not waste too much time. - have I mentioned I'm an "accidental" dba -- .net developer 85% of the time.
Thank you everyone for the replies & links posted, I've found them very informative. I think what i've got from this is to practice practice practice the different methods that may be needed for recovery.
In my experience sql server doesnt just stop starting correctly for no reason. Most likely\common reasons are missing folder (somone deleted tempdb folder) or missing permission to a folder.
In just about all cases the sql server log and windows app log will highlight the problem area, you just need to go fix it!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉