Link to home
Start Free TrialLog in
Avatar of hraja77
hraja77

asked on

how do i reclaim space in sql server 2005

Hi,
please help
how do i reclaim space in sql server 2005 - i have a table which grew out of control - i nned to now delete all the data and reclaim the space - do i shrink it or something - or does the space get reclaimed once the data is deleted - is there a high watermark issue like on oracle - do i need to truncat the table ???
Avatar of ptjcb
ptjcb
Flag of United States of America image

You can either shrink the database
http://msdn2.microsoft.com/en-us/library/ms189035.aspx

or shrink the file
http://msdn2.microsoft.com/en-us/library/ms190757.aspx

Both of the links have step-by-step instructions.
ASKER CERTIFIED SOLUTION
Avatar of assyst
assyst

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial