SQL Transaction logs filling fast

haxer · 04-26-2008, 05:47 PM

Hello. I need to know if anyone has experience with MSSQL. The problem I am having @ work is that some of our clients have databases in which they have 100mb for data and 200mb for transaction logs. We run into the issue where their transaction logs fill up fast and then of course their site errors. What is the most effective way to prevent this from happening.

I am looking for a specific query that can be done locally on the server through enterprise manager.

I would also like suggestion on maintenance plan for this if anyone has ideas as well.

hrofx566 · 11-24-2008, 04:42 AM

try the TRUNCATE LOG command, or just perform a db backup

04-26-2008, 05:47 PM	#1 (permalink)
haxer Private Join Date: Jun 2007 Location: Milwaukee, WI, USA Posts: 768 Thanks: 5 Thanked 12 Times in 12 Posts	SQL Transaction logs filling fast Hello. I need to know if anyone has experience with MSSQL. The problem I am having @ work is that some of our clients have databases in which they have 100mb for data and 200mb for transaction logs. We run into the issue where their transaction logs fill up fast and then of course their site errors. What is the most effective way to prevent this from happening. I am looking for a specific query that can be done locally on the server through enterprise manager. I would also like suggestion on maintenance plan for this if anyone has ideas as well. __________________ Looking for Mobters on Myspace? Check out www.MobsterAdd.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

11-24-2008, 04:42 AM	#2 (permalink)
hrofx566 Leecher Join Date: Nov 2008 Posts: 4 Thanks: 0 Thanked 0 Times in 0 Posts	try the TRUNCATE LOG command, or just perform a db backup

Sponsored Links