Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Analysis Services (2000)
 Restore DB with anther name

Author  Topic 

jeanh2
Starting Member

2 Posts

Posted - 2005-03-18 : 18:20:49
hello,

I want to restore a .cab but changing the name of the database. The idea is to use it during an installation process : the user gives the name of the database and restore our .cab with that name.

Is this possible?

Thanks!!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-03-18 : 18:42:07
Is this SQL Server? People usually use an extension of BAK for their backup files. If SQL Server, then

RESTORE DBNameGoesHere
...

Tara
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2005-03-18 : 19:43:53
I'm guessing you mean an Analysis Services database.

If it is, you should read the section "Archiving, Restoring, and Copying Data" in the "How To" section on Analysis Services in Books Online.


CODO ERGO SUM
Go to Top of Page

jeanh2
Starting Member

2 Posts

Posted - 2005-03-20 : 03:04:07
hi, thanks for your help... but...

I´m talking about Analysis services,

in the Books online, in the section "Archiving, Restoring, and Copying Data" in the "How To", they just mention the msmdarch but it is not possible to change the name with it. I need to get the same effect as in the "How to copy and paste an object" but from a command line or APIs, during an installation process using InstallShield...

Any idea? THANKS!




Go to Top of Page

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2005-03-20 : 06:17:18
You can't choose the name of the AS database during the restoration process :-(

rockmoose
Go to Top of Page
   

- Advertisement -