Hello!
I've got some backuped files from a 2000-server Analysis services and I need to import them into 2005. The problem is that I am not sure how these files where made and thus what they are. AFAIK they are simple dumps of databases. At least they have the same names:
msdb_db_<date>.bak (500Mb)
model_db_<date>.bak (800Kb)
and the actual database with data which doesn't have a file-ending at all.
These files are used as backup and apparantly it is possible to restore the 2000-server using them. Basicly this is all I know about these files. Is there any way I can do this? The background to this story is that I am trying to setup a testing 2005 server without touching the running 2000 server. Any other way I can do that?
Thanks!
I've moved the thread to the Analysis Services forum, where you should get an answer.|||You cannot restore Analysis Services 2000 backup files directly with Analysis Services 2005. Instead you need to resore them on AS2000 and then run MigrationWizard.exe to transfer the databases to AS2005 (or to generate a migration script that you can later run on AS2005).
You can invoke MigrationWizard.exe from SQL Management Studio, right click on the AS2005 item and use 'Migrate Database ...' option). Or directly from %ProgramFiles%.
Adrian Dumitrascu
|||I see, I'll try that. Thank you!
No comments:
Post a Comment