Jump to content

Initial SQL DB Size set to 327g

Recommended Posts

We got a notification over the weekend that the db was at 327g out 10g and we should upgrade to standard SQL, which is funny since this is an external db install!

Per this thread:

our DBA has truncated the tables, but says the initial db size is set to 327g (for about 1200 endpoints) and even though she can shrink the db, the size of the db will remain at 327g. The management console is extremely pokey and takes several minutes to become usable when starting. If I accidentally click on the home tab then I can expect another few minutes before I can do anything else.

How can we shrink the db and get the initial size to a more manageable number?


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
Back to top
  • Create New...

Important Information

This site uses cookies - We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.