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.

Books to Read: an update

Update on books to read:
1. T-SQL 2000 – Itzik Ben Gan
Re-read 3 chapters. Downloaded the SQL scripts in the book from the publisher’s website. I did not know that they existed. That will make a good reference.

3. Fast Track to MDX – Mosha
Almost done. Need to finish the last chapter.

8. SQL Server 2005 Analysis Services Step by Step – Reed
Good read. Read most of the book and found it very useful in building cubes in 2005.

I will concentrate on finishing the above books and move on to the other ones.

Books to Read

Books that are on my shelf that I need start reading, reread or finish off reading:

1. T-SQL 2000 – Itzik Ben Gan
2. Data Warehouse Toolkit – Kimball
3. Fast Track to MDX – Mosha
4. 2 minute SQL Stumpers – sqlservercentral.com
5. Analysis Services 2005 – Malomed at el
6. MDX Solutions – George Spoffard
7. Data Mining with SQL 2005 – Jamie Mac et al
8. SQL Server 2005 Analysis Services Step by Step – Reed