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.
    
        | 
                
                    | 
                            
                                | Author | Topic |  
                                    | jeanh2Starting 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!! |  |  
                                    | tkizerAlmighty 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, thenRESTORE DBNameGoesHere...Tara |  
                                          |  |  |  
                                    | Michael Valentine JonesYak 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 |  
                                          |  |  |  
                                    | jeanh2Starting 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! |  
                                          |  |  |  
                                    | rockmooseSQL 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 |  
                                          |  |  |  
                                |  |  |  |