dbTalk Databases Forums  

Two analysis databases named the name in SQL2005

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Two analysis databases named the name in SQL2005 in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
billg51@yahoo.com
 
Posts: n/a

Default Two analysis databases named the name in SQL2005 - 09-26-2005 , 02:56 PM






In SQL2005 Analysis Server, I have two databases named the same. I try
to do anything (delete, rename, process, etc..) and get the following
error.

"Deserialization failed: Another database object has the 'XYZ' name."

So I cannot do anything with any of the databases there now. I was
trying to restore a database to a different name, and this is what
looked to screw it up.


Reply With Quote
  #2  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: Two analysis databases named the name in SQL2005 - 09-27-2005 , 06:10 PM






No, you cannot have two databases with the same name.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


<billg51 (AT) yahoo (DOT) com> wrote

Quote:
In SQL2005 Analysis Server, I have two databases named the same. I try
to do anything (delete, rename, process, etc..) and get the following
error.

"Deserialization failed: Another database object has the 'XYZ' name."

So I cannot do anything with any of the databases there now. I was
trying to restore a database to a different name, and this is what
looked to screw it up.




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.