Bug 778119 (SOA-629)

Summary:	Update rel. notes: MSSQL How to reclaim disk space
Product:	[JBoss] JBoss Enterprise SOA Platform 4	Reporter:	Martin Vecera <mvecera>
Component:	Documentation	Assignee:	Dana Mison <dmison>
Status:	CLOSED NEXTRELEASE	QA Contact:
Severity:	high	Docs Contact:
Priority:	high
Version:	4.2 CP02
Target Milestone:	---
Target Release:	4.3 CR1
Hardware:	Unspecified
OS:	Unspecified
URL:	http://jira.jboss.org/jira/browse/SOA-629
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2008-10-20 09:07:53 UTC	Type:	Task
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:

Description Martin Vecera 2008-07-14 13:57:56 UTC

Affects: Documentation (Ref Guide, User Guide, etc.), Release Notes
Date of First Response: 2008-09-15 00:22:46
project_key: SOA

See linked issue for the problem description. We should put the final solution into release notes.

Comment 1 Martin Vecera 2008-07-14 13:58:15 UTC

Link: Added: This issue is related to JBMESSAGING-1359

Comment 2 Martin Vecera 2008-07-14 13:59:30 UTC

Link: Added: This issue related SOA-565

Comment 3 Dana Mison 2008-09-15 04:22:46 UTC

Proposed content for release notes - known issues:

Using Microsoft SQL Server as a database.

Microsoft SQL Server does not automatically deallocate the harddrive space occupied by data in a database when that data is deleted.  If used as a datastore for services that temporarily store many records, such as a messenging service, the disk space used will grow to be much greater than the amount of data actually being stored.

Your database administrator should implement database maintenance plans to ensure that unused space is reclaimed.  Please refer to your Microsoft SQL Server documentation for the DBCC commands ShrinkDatabase & UpdateUsage for guidance.

Comment 4 Martin Vecera 2008-10-06 08:15:26 UTC

Cannot verify this fix with IR5 since the docs package is not correct and doesn't contain release notes (SOA-889).

Comment 5 Martin Vecera 2008-10-20 09:07:53 UTC

Verified with CR1.