Results 1 to 3 of 3

Thread: [RESOLVED] Need to compact an SQL Express database

  1. Jan 19th, 2007, 04:12 PM #1
    ghall426
    ghall426 is offline

    Thread Starter
    Member
    Join Date
    Sep 2006
    Posts
    63

    Resolved [RESOLVED] Need to compact an SQL Express database

    I am using VB Express 2005 with an SQL Express 2005 database. I had filled it with an equivalent of 10 years of data to check performance. I have deleted the data and need to compact the database to shrink the size of the database file.

    I have searched extensively but am unable to find any useful information on it. Can somebody please help?

    Greg
    Reply With Quote Reply With Quote
  2. Jan 19th, 2007, 06:06 PM #2
    Asgorath
    Asgorath is offline
    Frenzied Member Asgorath's Avatar
    Join Date
    Sep 2004
    Location
    Saturn
    Posts
    2,036

    Re: Need to compact an SQL Express database

    See
    Code:
    DBCC SHRINKDATABASE
    Jorge
    "The dark side clouds everything. Impossible to see the future is."
    Reply With Quote Reply With Quote
  3. Jan 19th, 2007, 09:43 PM #3
    ghall426
    ghall426 is offline

    Thread Starter
    Member
    Join Date
    Sep 2006
    Posts
    63

    Re: Need to compact an SQL Express database

    That did it. Thanks.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width