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!

Help - shrink file or shrink database?

Status
Not open for further replies.

icemel

MIS
Oct 17, 2005
463
US
Hi, I have a database made of file groups.

I just truncated a huge table in one of the file groups. I now need to shrink the database in order to free up the space to the os.

Should I use the shrink database or shrink file command to do this? I don't have much experience working w/ filegroups.

Thanks much
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top