Restore DB with Different Name – Limitation
Posted by ihafidh on November 14, 2007
Got this error trying to rename a SSAS 2005 database:
“Backup and restore errors: Restore under different DatabaseId/DatabaseName can not be done for a database with partitions with specific location.”
Apparently, there is a limitation with SSAS 2005 when you try to restore a database with a different name AND you have specified a different folder location for storage. Hopefully this limitation is removed in SQL2008.
I had specified a different location because I ran out of space on my default location.
