|
| | | Forum Guru
 
Group: Forum Members
Last Login: 7/28/2008 3:18:53 AM
Posts: 56, Visits: 23 |
| | Our MSDE database on a WUG11.0.3 install is at 90% So, to reduce this, so I don't run into any problems, I've reduced the Report Data values again (from 300 to 200 days - see attachment) and run "Validate and Compact", "Check for fragmented tables" and "Purge Expired Rows". However, according to WUG, the database size is still the same! Any ideas what I could do next? Thanks
|
| |
| | | Forum Guru
Group: Forum Members
Last Login: 7/28/2008 3:18:53 AM
Posts: 56, Visits: 23 |
| | I've now removed "Interface Utilization" from ALL items' Performance Monitors. Run "Purge Expired Rows", "Check fro fragmented tables" then "Validate and compact database". Still the same! I've backed up the database from within Whatsup and the database.dat file size is 560MB. However WUG sees the SQL database size as 1854.8MB. Any suggestions anyone? |
| |
| | | Forum Newbie
Group: Forum Members
Last Login: 7/24/2008 11:59:16 AM
Posts: 2, Visits: 14 |
| | Run these commands from a dos prompt to actually shrink the physical database. Replace 'whatsup' with whatever name you used if you didn't accept defaults. When it's finished enter 'exit'. osql -E -D whatsup 1>DBCC SHRINKDATABASE ('WHATSUP') 2>GO |
| |
| | | Forum Guru
Group: Forum Members
Last Login: 7/28/2008 3:18:53 AM
Posts: 56, Visits: 23 |
| Cheers Dave, that did the trick!1> DBCC SHRINKDATABASE ('WHATSUP')
2> GO
DbId FileId CurrentSize MinimumSize UsedPages EstimatedPages
------ ------ ----------- ----------- ----------- --------------
5 1 72704 1024 71520 71520 (1 row affected)
DBCC execution completed. If DBCC printed error messages, contact your system
administrator.
Database was 1854MB - now 568MB! |
| |
| | | Forum Newbie
Group: Forum Members
Last Login: 8/28/2008 1:48:18 PM
Posts: 5, Visits: 30 |
| | Just to float this to the top again, this did the trick for me as well on v11.0.3. I emailed IPSwitch support asking why this command did what the built-in WUG db shrink dialogue does not. No monitors were disabled (though I did go from 1 yr to 200 days worth of retention) and I went from from ~53% utilization down to 11%. |
| |
|
|