Checkbox clears for transaction log maintenance plans

Question

Post reply

Checkbox clears for transaction log maintenance plans

Kwisatz78

SSChampion

Points: 12478
More actions
January 11, 2010 at 2:38 am

#214344

Hi all - I just wanted to be sure other people see this issue when wanting to add a new database to an existing transaction log backup maintenance plan, that when you choose the drop down menu it clears all the checks from the list of databases you had previously selected, and you have to check them all again.
This is happening on two seperate instances.
Thanks

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

homebrew01 SSC Guru Points: 55553 More actions · Answer 1

No, Mine were still checked. Are you up to date with service packs ?

Kwisatz78 SSChampion Points: 12478 More actions · Answer 2

Kwisatz78

SSChampion

Points: 12478

January 11, 2010 at 9:36 am

#1101900

we are on SP2 atm

homebrew01 SSC Guru Points: 55553 More actions · Answer 3

I created a new Maint Plan when I tried it just now. Perhaps there's a quirk in your existing plan if it was created on an earlier SP ? (wild guess)

Jeffrey Williams SSC Guru Points: 90350 More actions · Answer 4

There were known issues in SP2 with the Check Database Integrity task and the Execute SQL Task losing database context. I believe this was also seen on the backup tasks.

Verify that you are on at least 9.0.3054 or later and also verify that your client tools have been upgraded. I have seen this kind of issue when trying to use RTM/SP1 tools against an SP2 system.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

Kwisatz78 SSChampion Points: 12478 More actions · Answer 5

Ok right thats interesting.

I have checked and our instance is 9.00.3077.00 and the client tools is 9.00.3042.00. I think both of these are SP2 but with some additional fixes for 3077?

I wonder if thats causing the problem.

Also is there a link to a website that tells me eactly what versions each number is?

Thanks

Jeffrey Williams SSC Guru Points: 90350 More actions · Answer 6

http://www.sqlservercentral.com/articles/Administration/2960/

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

Kwisatz78 SSChampion Points: 12478 More actions · Answer 7

Kwisatz78

SSChampion

Points: 12478

January 13, 2010 at 3:13 am

#1102950

oh great thanks