May 22, 2006 at 7:27 am
Hi
ive implemented transactional log backups on my live server to run every 15 min, problem is whenever it runs its hangs up the application,resulting in abt 6 minutes of downtime or so , can anyone suggests any work arounds?The db is set to full recovery mode.
It is currently backing up to a local drive that is on a seperate physical disc and controller than the MDF and LDF,
ps the DB is 440G.
May 25, 2006 at 12:47 pm
You might also want to check to see if the disk is causing the contetion, check the disk queue length parameter in the perfmon. A cheaper workaround would be to take a backup in shorter intervals.Since the db is large and it takes about 6 minutes to take a log backup every 15 minutes, try taking a log backup once every 2 minutes. This way the time taken for the backup would be very less and probably small enough not to cause performance problems to the application.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply