Hello,
is it possible to restore a sql olap database with a different name? ie I have prd database Sales, i would like to archive then and then restore to Sales_Dev. is it possible using AS manager or msmdarch?


Thanks

Bakup database Sale
Create NEW database with name Sales_De

us
"restore from device" => select backup fil
with option/force restore over existing database

Maybe there is a better solution but this works
Restore the database normally
Using Analysis manager, copy the database and then paste it
AS will prompt you for a new name
The catch is that you will have to reprocess the dimensions and cubes, though
HTH
Bria
www.geocities.com/brianaltmann/olap.html

Hello,
as i mentioned , I need to restore a analysis services database with a
different name. As I undrestand, you described anout sql server database
restoring??

Ramunas

"Alex" <alex_priv (AT) interia (DOT) pl> wrote