RDMC SQL Database Log Size

SOESoft Support Forum

Forums Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

RDMC SQL Database Log Size

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [SOESoft Knowledge Base Articles] >> Knowledge Base >> RDMC SQL Database Log Size

Page: [1]

Message

<< Older Topic Newer Topic >>

RDMC SQL Database Log Size - 19/5/2009 5:35:52 AM

Developer

Posts: 165
Score: 0
Joined: 31/7/2005
Status: offline

The RDMC system itself does not utilise a database however if you have the advanced reporting module that uses the RDMC SQL import engine then the following SQL statements can be used to limit the transaction log file size:

To prevent the transaction log from consuming disk resources execute the following SQL statements:

ALTER DATABASE [Database_Name] SET RECOVERY SIMPLE

And then..

DBCC SHRINKFILE ([Log_File], EMPTYFILE)

(Replacing “[Database_Name]” with the name of the database and “[Log_File]” with the name of the transaction log file to shrink)

EXAMPLE:
(
ALTER DATABASE RDMCInventory SET RECOVERY SIMPLE

DBCC SHRINKFILE ('RDMCInventory_SOESoft_log', EMPTYFILE)
)

After executing the SQL statements the transaction log file will no longer grow.

< Message edited by Developer -- 19/5/2009 5:37:13 AM >

_____________________________

SOESoft Support Team
SOESoft Pty Ltd
Product Development
support@soesoft.com

Unit 6, 4 Queen St
Bentley 6102
Perth, Western Australia
+61 (0)8 9258 8888
http://www.soesoft.com