Smaller Database

Hot Topic

Dynamic queries on Access databases
What has .tabenabled changed to in .NET?
Run, Message, Delete
Picturebox change forecolor
Problem with Tab Groups in VS2005, programing in C#
Help with VB 6.0 and Access 2002
Problem with Control Focus
Comments Preceding Code On Single Line
Loading Crystal Reports Report, How To Stop Prompt Enter Login ID And Password, This Never Happen Before
how to send personalized alerts to another machine using vb.net

Visual Basic

Build Complete Notification Sounds - another workaround
MDI Forms
screen scraping windows apps
Add a web Srvice As a data source
My.Resources in VB2005
help me about data Grid
edit and continue
External protocol in IE:D (advanced registry edit?)
vb6 to VB.Net upgrading Sub Main() error
How do I find documentation on specific classes or objects?

Smaller Database

I have an application in VB 2005 Express with a SQL Server database.  I added large amounts of data for debugging purposes.  However, I want to ship an empty database, so I deleted all of my data, yet the database did not go back to its original smaller size.  Is there a reason for this, or anyway to correct it   Thanks

-Aviatordave

Answer this question

Smaller Database

  • CPrecourt

    If it's a SQL database, just export the database shema. You can import the schema again into the new server. You dont' have to export the data (if any)

    The files are still big because the tables won't autoshrink. if they grew and shrunk automatically, it would slow it down considerably.


  • BillFugina

    That sounds like it would probably work, except I have no idea how to do that, and I couldn't find anything in the documentation. Can anyone stear me in the right direction on how to do that Or have any other ideas.

    Thanks!
    Aviatordave
  • Smaller Database
Answer this question