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 ???
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 ???
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.