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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
TempDB 1
- Thread starter CasperTFG
- Start date
-
1
- #3
The others aren't saying it but DON'T EVEN THINK OF DOING THAT.
First....SQL Server won't work without TEMPDB. Go to Enterprise Manager, drill down to Management, expand that and find your latest SQL Server Error log. Look at the order the databases start up....what's first? TEMPDB. Nothing will work without that.
Second....if you really need to recreate the TEMPDB, just stop and restart the SQL Server services.
-SQLBill
Posting advice: FAQ481-4875
First....SQL Server won't work without TEMPDB. Go to Enterprise Manager, drill down to Management, expand that and find your latest SQL Server Error log. Look at the order the databases start up....what's first? TEMPDB. Nothing will work without that.
Second....if you really need to recreate the TEMPDB, just stop and restart the SQL Server services.
-SQLBill
Posting advice: FAQ481-4875
- Status
Similar threads
- Locked
- Question
- Locked
- Question