Wednesday, March 28, 2012

new tempdb file shrinking

since the tempdb file was growing to large I created a new one on another
drive; now that file is getting to large; I need to shrink it. both the
original "tempdev" file and the new one "tempdb_1_data" are in the PRIMARY
group but the "tempdev" is locked to 1 MB while "tempdb_1_data" is now 36GB
and growing. only about 1GB of the 36GB is used.
remember i don't want to shrink the original sql server created temp file
"tempdev"
can I use dbcc shrinkfile (tempdb_1_data, 2000) without a problem? and
without having to restart the sql service?http://www.aspfaq.com/2446
http://www.aspfaq.com/2471
http://www.aspfaq.com/
(Reverse address to reply.)
"Peter L." <Peter L.@.discussions.microsoft.com> wrote in message
news:8FD556CF-ED9A-41BD-80EA-6C5E604EEEBB@.microsoft.com...
> since the tempdb file was growing to large I created a new one on another
> drive; now that file is getting to large; I need to shrink it. both the
> original "tempdev" file and the new one "tempdb_1_data" are in the PRIMARY
> group but the "tempdev" is locked to 1 MB while "tempdb_1_data" is now
36GB
> and growing. only about 1GB of the 36GB is used.
> remember i don't want to shrink the original sql server created temp file
> "tempdev"
> can I use dbcc shrinkfile (tempdb_1_data, 2000) without a problem? and
> without having to restart the sql service?sql

No comments:

Post a Comment