Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Central Management Server db Huge

Author  Topic 

Wrangler
Starting Member

35 Posts

Posted - 2011-06-13 : 11:14:25
Greetings,

Our Central Management Server database is almost 300 gig and growing. I'd like to trim it down to about half the size if possible. Is there a query or function to run to purge some of the older data?

Thank you,

mikgri
Starting Member

39 Posts

Posted - 2011-06-14 : 14:50:19
First i will shrink database and look how size of database change, you can shrink files as well.
Go to Top of Page
   

- Advertisement -