I would like copy an existing production cube to a test environnment in the same server by changing the destination name.
I found nothing to rename the cube before archive or during the restore.
Changing the name of the archive does not change the restauration name.
Hi Georges
Copy and paste the cube with a new name (right click) then reload the cube.
Chris
I use SQL Server 2000 ( could be developer version )
Is there a way to re-register a database.
I have one .MDF file and a log file.
Every menu i have been thrue but no luck.
Is this possible or do i need to add a new database?
Thnaks,
Dennis1. Open Enterprise Manager
2. Open up the tree under your server until you see the "Databases" section.
3. Single click to select it.
4. Right-Click and select "All Tasks->Attach Database"
5. Select your mdf file.|||McMurdoStation,
you have saved me a lot of work.
Thanks a million,
Dennis
