4/20/2024 3:36:27 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss SQL Server or Oracle database administration related to SalesLogix databases. View the code of conduct for posting guidelines.
|
|
|
|
saleslogix_log file size
Posted: 21 Aug 06 3:22 PM
|
fiogf49gjkf0d Any help would be greatly appreciated. The salelogix_log needs to be reduced in size. How do I go about this?
|
|
|
|
Re: saleslogix_log file size
Posted: 22 Aug 06 6:39 AM
|
fiogf49gjkf0d First, you need to adjust your backup schedule so that your log doesn't keep growing. If you are not processing incremental backups and your recovery model is not set to simple this is pretty common with SQL 2000. The log is designed to get cleaned out when a incremental backup is complete.
Here is how you go about reducing the size after you have corrected your backup schedule.
execute the following SQL Statements on your SalesLogix Database
First you need to empty the Transaction log
DUMP TRAN SalesLogix WITH NO_LOG
Now you can Shrink the database(this will reduce your log file size back to normal)
DBCC SHRINKDATABASE(SalesLogix,10)
If you are not using incremental Backups run the following statement to stop your log file from getting out of control
SP_DBOPTION 'SalesLogix','trunc. log on chkpt.',true
If you are not sure what database options are currently set run the following
SP_DBOPTION 'SalesLogix'
I hope this help!!
|
|
|
| |
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|