Friday, February 17, 2012

Error 21776: [SQL-DMO] The name XXXX was not found in the Database collection.

Hi,

This is the error that I am getting after an unsuccessfuldatabase attachment.
Error 21776: [SQL-DMO] The name 'XXXX' was not found in the Databasecollection. If the name is a qualified name, use [] to separate various partsof the name, and try again.
Any ideas how can I delete that database?
Thanks

did you copy a database file from another server ?|||I think it is good practice to restore from your last backup, it leaveseverything in place until you are ready to delete the database. The backup and restore wizard will move everything if you use restorefrom Device. You can also use Network Share as your location ofthe files to restore. Hope this helps.
Kind regards,
Gift Peddie
|||Hi,
Yes I did try to move from one server to the current one, the solution was to restore it from an existing backup.
Just wondering if the operation fails, nothing should happen. Any way thanks for the ideas.
|||check if thislink helps.

No comments:

Post a Comment