tempdb

[ThomH]

Someone increased the database size of the tempdb to 42 gig. The file is now 42 gig. This is the mdf. How to we reduce, or create a new one!

 

[bborissov]

Restart the SQL Server, that would recreate TempDB.

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[ThomH]

I tried this, but did not work. The tempdb properties are set to 42,960 under the Space allocation, and I can't change that.

 

[onpnt]

Are you a sysadmin?

[sub]____________ signature below ______________
You may get help by means of code here. Just recall what happens to a rat when he eats the cheese off a rat trap while you're Ctrl+C/Ctrl+V'ing that code as your own[/sub]

 

[ThomH]

YES

 

[onpnt]

http://support.microsoft.com/kb/307487

[sub]____________ signature below ______________
You may get help by means of code here. Just recall what happens to a rat when he eats the cheese off a rat trap while you're Ctrl+C/Ctrl+V'ing that code as your own[/sub]