Bug 778119 (SOA-629) - Update rel. notes: MSSQL How to reclaim disk space
Summary: Update rel. notes: MSSQL How to reclaim disk space
Keywords:
Status: CLOSED NEXTRELEASE
Alias: SOA-629
Product: JBoss Enterprise SOA Platform 4
Classification: JBoss
Component: Documentation
Version: 4.2 CP02
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: 4.3 CR1
Assignee: Dana Mison
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2008-07-14 13:57 UTC by Martin Vecera
Modified: 2008-10-20 09:07 UTC (History)
0 users

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2008-10-20 09:07:53 UTC
Type: Task

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 778040 0 high CLOSED JBM is not able to work with MSSQL - MSSQL cannot reclaim disk space used by JBM_MSG table 2021-02-22 00:41:40 UTC
Red Hat Issue Tracker SOA-629 0 None None None Never

Internal Links: 778040

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.
Note You need to log in before you can comment on or make changes to this bug.