I have something around 52 DB's and out of 52 DB's nearly 25 DB has log_resue_wait_desc = 'LOG_BACKUP'

Ok, I will try that!

I will try that! Thanks,!

Thanks Gail!

just a thought!

Can I go ahead and shrink the msdb log file?

ok, which this situation what steps needs to be follow?

The error is fixed.

I ran the following in command prompt and it cleared the error in maintenance plans.

"\Program Files (X86) \Microsoft SQL Server\100\DTS\Binn\regsvr32.exe DTS.dll".

thanks

Can anyone help me why I am getting this error i Maintenance plans

===================================

Exception has been thrown by the target of an invocation. (mscorlib)

------------------------------

Program Location:

at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean...

Thanks!

Hi Gail,

I got the same "LOG_BACKUP" in sys.databases. I will do the same steps(full to simple and then run checkpoint, change to full, then take full or differential backup, then...

Got it! Thanks.

Now Transaction log backup is working fine, after I did the above said steps. Now my question is in future if I faced the same situation, I need to do...

Better I will do after office hours.

Thanks.

Can I change the recovery to simple and run a checkpoint when users are accessing the DB?