@@@ Steve, GTR and Jason; Thank you for your response.

There is no maintenance plan for transaction log backup. Logshipping is not taking place.

But, there are transaction log backups...

No..That is the only message.

Hi,

I think, the error is due to incorrect settings (Quoted_Identifier option) in the databases. We probably need to check off the Quoted_Identifier option in the databases for which the maintenance...

Hi Jason,

I guess, I figured that out. There was a mistake in my T-SQL in step 1.

Thank you

Thank you Roy!

Thank you very much Eric,

Hi Roy,

Thanx for your reply. Is there any other way we can do this in 2000 and 2005 versions of sql server?

Hi Jay,

Thanks a lot. I think the Scenario 1 mentioned by you matches with my problem.

Thanks to others also who replied for this post.