Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    53

    Unanswered: How can I compact MS SQL 2000 Database?

    Now my database is contain a big size and still grow up. I think may I can compact it to small size like ms-access.
    How can I compact MS SQL 2000 Database?

  2. #2
    Join Date
    Aug 2002
    Location
    india
    Posts
    41

    you can shrink the database

    You can shrink the databse by any of the following option.

    1.You can use the syntax dbcc shrinkdb <databasename> on query analyzer

    or

    2.selse sqlserver -> enterprise manager ->select the database -> right clik this and select the option shink

    for more information u can use books online shrink database option

  3. #3
    Join Date
    Dec 2002
    Location
    Antwerp, Belgium
    Posts
    227
    To prevent the database from unwanted growth, you can set the 'Auto shrink' option (in Enterprise Manager, right click on your database, choose properties, select options tag and check the auto shrink option).
    Johan

Posting Permissions

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