[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 930
  • Last Modified:

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 ???
0
hraja77
Asked:
hraja77
1 Solution
 
ptjcbCommented:
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.
0
 
assystCommented:
You can truncate the table if there is no foriegn key constraint. It will have use less transaction log resource as it just logs the page deallocation.
It will all free all the data pages for re_use.
 
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now