September 15, 2003 at 3:16 am
I have set up a maintenance plan for a user database. Everything works fine except for the transaction log.
I have set the transaction log to backup hourly between 06:00 - 22:00 Mon - Sat.
The transaction log actually only gets backed up for one day. The next day the maintenance plan on the transaction log schedule has the enabled checkbox unchecked. Same with the transaction log job.
I have checked the box several times to no avail. What's going on?
September 15, 2003 at 3:38 am
I have seen this before, if I recall right this is a bug. Try to change your tran log from running 06:00-22:00 to running 06:00-22:15 (or anything other than the same ending seconds as the start)
HTH
Ray Higdon MCSE, MCDBA, CCNA
------------
Ray Higdon MCSE, MCDBA, CCNA
September 16, 2003 at 2:52 am
Ray, I changed the time to 22:05 and this morning it is working ok.
Many thanks
Stefan
September 16, 2003 at 3:04 am
Great!
Ray Higdon MCSE, MCDBA, CCNA
------------
Ray Higdon MCSE, MCDBA, CCNA
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply