Database not found error....

• shwetha

  Ten Centuries

  Points: 1248

  More actions

  September 10, 2007 at 2:27 pm

  #125658

  Hi,

  I have a maintenenace job with multiple steps (optimization,integrity and update stats)that runs every weekend, but this weekend something weird happened, the Integrity step in the maintenance job failed with the following error -

  [Microsoft SQL-DMO] Error 21776: [SQL-DMO]The name 'xyz' was not found in the Databases collection.  If the name is a qualified name, use [] to separate various parts of the name, and try again.

  Does anyone have idea as to why it would fail with such an error, the database is very much there.

  Thanks & regards!

• sqldba-294117

  Hall of Fame

  Points: 3486

  More actions

  September 10, 2007 at 4:20 pm

  #732626

  see the Reports log under LOG folder if it is configured to do so. that will give you some more information or post message from Report logs. thx

   

• shwetha

  Ten Centuries

  Points: 1248

  More actions

  September 11, 2007 at 8:04 am

  #732792

  Thanks for your response, the error message I posted was from the the LOG folder.

  Thanks & regards!!