I have a client with intergrated Great Plains and CRM 1.2.
The MSCRMIntegration database has increased in size . Last night it was up
to 7.5 GB. I shrank the database to 6.3 GB but I cannot get it below that.
I am leaving 1 percent free space after the size reduction.

In EM I cannot reduce the size lower than 6.3 GB.

My options so far are to add another drive and move the MDF and the LDF over
to that drive, and add a drive for a new backup location. Servers located at
a datacenter and scheduled downtime is limited.

I've checked partnersource on the GP and CRM side. Not much there on this
issue.
\:>

Just a quick SQL point; the default settings in Enterprise Manager only
remove space from the end of the data files if using the Shrink Database
dialog. This dialog calls the DBCC SHRINKDATABASE command, which cannot
always shrink files as much as you'd expect.

If you haven't already, try using DBCC SHRINKFILE, or use Shirnk File dialog
(from the Files button on the Shrink Database dialog in EM) with the
'Compress pages and then truncate...' option.

With a 6.3GB database you may want to schedule this, as it may take some time

"Curt Spanburgh" wrote: