Wednesday, November 14, 2007

Restore DB with Different Name - Limitation

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.

No comments: