How do you determine the best size for tempdb (i.e. rule of thumb is 2
times the largest table in the DB) and should tempdb be allowed to grow
Sent via Deja.com http://www.deja.com/
Before you buy.
SQL Server MVP
SQL Server Magazine Columnist
> Sent via Deja.com http://www.deja.com/
> Before you buy.
I have increased the size of my tempdb database to accomodate a large number
of users. I created a device file for the new portion and expanded tempdb
onto it. Now I have two questions and was wondering if anyone could help
1) How do I start SQL Server if I lose the second device file. (I removed it
on purpose from my test database and it will not start)
2) How can I completely move the tempdb database off of the master device so
it resides completely on its own device
Any help would be appreciated