Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Location
    Bangalore
    Posts
    28

    Unanswered: Deleting records to save DISK Space...

    Hi,

    In my data archiving process , I would end up deleting hunders records from the production databases but would that help me save some DISK space immediately??? Should I run some DBCC command to get some disk space ?

    if SO ..!! What should I do after deleting the records..????

    Thanks
    Cheriyan.

  2. #2
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    "Always be sure to backup your records ... before you delete them ... "
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  3. #3
    Join Date
    Mar 2004
    Posts
    114
    Have a look in SQL Book online to this command

    Code:
     
    DBCC SHRINKDATABASE 
        ( database_name [ , target_percent ] 
            [ , { NOTRUNCATE | TRUNCATEONLY } ] 
        )

  4. #4
    Join Date
    Aug 2004
    Posts
    15
    Kim Tripp presented a good session at the PASS conference a couple weeks ago about removing data using filegroups. If you are a PASS member, you can download the presentation here:

    http://ew.sqlpass.org/ew/pass/callpa..._For_Print.zip

    Anyone can also download her scripts here:

    http://www.sqlskills.com/pastConferences.asp

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •