Post reply

Backup, integrity, optimzation jobs failing

  • February 17, 2010 at 3:41 pm

    #145296

    Hi All,

    I have three jobs: DB Backup, Integrity Job & Optimization job for a DB maintenance plan. All these three jobs are failing in one server. Can someone help me?

    Thanks in advance

  • February 17, 2010 at 3:53 pm

    #1120530

    What is the error message?

    EnjoY!

    EnjoY!

  • February 17, 2010 at 3:54 pm

    #1120531

    The three SQL Agent jobs should be failing and giving an error, can you post the error that these are giving?

    Also is there anything untoward in the SQL error log?

    Gethyn Elliswww.gethynellis.com

  • February 17, 2010 at 4:13 pm

    #1120544

    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 plan is designed.

    Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

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