Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Server TEMPDB WARNING

SQL Server Administration

SQL Server TEMPDB WARNING

by  CasperTFG  Posted    (Edited  )
It was suggested i make an FAQ for this so here ya go.

Just for anyone new to SQL Server (As I just assisted another with this problem) [color red]Do not put data you want to keep into the TEMPDB created automatically by SQL Server.[/color]

I had a client who wanted to re-create his DB, he moved all the data into TEMPDB, droped the old database, but then just as he was creating the new DB, the Server PC locked up and crashed.

When he rebooted all of his data was gone. This is quite normal apparently with SQL Server, If you read the docs you'll see that SQL Server will drop and recreate the entire TEMPDB database everytime the server is started.
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top