Server wont''s start? urgetn plz

Question

Server wont''s start? urgetn plz

SQLRep

SSCrazy

Points: 2052
More actions
July 26, 2006 at 2:39 pm

#61061

Hi all
somehow my sql server is not starting up!!
in event viewer it says that it could not find the tempdb file!!
what can id do to reslove it...
Thanks

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

John Rowan SSC Guru Points: 56440 More actions · Answer 1

I would first check and make sure you did not lose a disk. Then look in the folder where you would normally keep your TempDB and make sure it is truely gone. It will be in the default installation data folder unless you've moved it off onto it's own RAID/drive. If it is truely missing, grab a copy of a TempDB from another server if you can. Keep in mind any sizing changes you may have made to your TempDB and make sure the new Tempdb.mdf is sized correctly for your needs.

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

SQLRep SSCrazy Points: 2052 More actions · Answer 2

I am missing that drive!! so how can i put new temp db file from another db server and also can i re direct it so can server get restarted!!

Thanks

John Rowan SSC Guru Points: 56440 More actions · Answer 3

Unless there is some magical way to make SQL Server look for the tempdb in a new location, you are down until you repair/replace the drive. SQL Server is looking for the TempDB in a specific location. Copying a new TempDB will not do you any good because SQL Server is looking for the TempDb in a specific location. If that location does not exist due to the drive being down, it will not start. Was your TempDb not in it's default location? It sounds like you've moved it out to it's own disk for performance reasons. I would recommend some sort of redundancy (I would use mirroring) on your TempDB disk in the future.

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

John Rowan SSC Guru Points: 56440 More actions · Answer 4

Rebuilding your master database may get you going again. You may want to look into that option as well.

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

John Rowan SSC Guru Points: 56440 More actions · Answer 5

Sorry to keep bombarding you, but check this out. You may be able to get back up without repairing/replacing your disk.

http://dis4ea.blogspot.com/2005/07/tempdb-and-missing-device.html

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

andrewkane17 SSCertifiable Points: 7529 More actions · Answer 6

John,

Not in this situation myself, but saved the web page

http://dis4ea.blogspot.com/2005/07/tempdb-and-missing-device.html

to my docs and this gives me what I need in the future if I get the call in the weee hours

Dave -310292 Old Hand Points: 360 More actions · Answer 7

This is the best way that I have found to move a Tempdb to a new drive location when a drive fails. Scroll down on the article until you see the section for moving the tempdb.

http://support.microsoft.com/?id=224071

WesleyB Ten Centuries Points: 1307 More actions · Answer 8

Hi,

If you are using SQL Server 2005 the procedure of rebuilding your master and thus resetting the tempdb location. You now have to rebuild it from the command prompt.

FROM BOL:

start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<NewStrongPassword> SQLCOLLATION=<NewSystemCollation>

Read the topic "How to: Install SQL Server 2005 from the Command Prompt" in the Books Online carefully since you will have to do some additional step to get back to the 'old' situation. We have succesfully used this procedure to recover from a missing tempdb device.

But being a SQL Server 7/2000 forum I suppose the procedure on my blog should do the trick (since we also used this succesfully on another server). We've had some bad luck with TempDB 🙂

HTH