how do i reclaim space in sql server 2005

Posted on 2007-10-10
Last Modified: 2012-08-14
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 ???
Question by:hraja77
    LVL 27

    Expert Comment

    You can either shrink the database

    or shrink the file

    Both of the links have step-by-step instructions.
    LVL 7

    Accepted Solution

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    If you find yourself in this situation “I have used SELECT DISTINCT but I’m getting duplicates” then I'm sorry to say you are using the wrong SQL technique as it only does one thing which is: produces whole rows that are unique. If the results you a…
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Viewers will learn how the fundamental information of how to create a table.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now