May 5, 2009 at 7:44 am
Hi,
I tried to 'Archive Database...' but the fact file of one of the cubes is too big to fit in the .CAB archive file..
Would the following scenario work OK?
1. I temporarily restrict/filter the fact data of that cube, process it anew and
2. Choose the database and 'Archive Database...' to the new location and then
3. From the AS server level 'Restore database...' from the new location
If this is OK then must I first delete the current database from the server tree or will the Restore database overwrite it?
and everything should work as before...right?
Ville
ps. migration is not on option in this place
May 5, 2009 at 7:54 am
I hope you mean “Backup” when you say “Archive”. However, database backup has .BAK extention and not CAB.
Anyway, you can detach database from SQL Server, copy files (mdb and/or ldf) to another location, rename original files something else (just in case copy will not work), and attach database using new location.
Sometimes, application cannot work with database after attach because it looks to the database ID and not to database name. When you detach/attach database its ID will be different.
However, it is very dangerous if you can’t backup the database because you can lose it all if a hard drive crash, for example.
Hope it is helpful.
Alex Prusakov
May 5, 2009 at 8:06 am
Hi
I'm trying to do this for Sql2000 Analysis Services (AS) database
...already executing my plan as I described
Ville
May 5, 2009 at 10:30 am
Hi,
FYI
it worked fine, the AS database structure with all the cubes were created to the new location with the 'Restore database' but after the restart of the service the data files still get updated in the old place... I'm a bit lost here. What else should I do?
Ville
May 6, 2009 at 3:31 am
Hi again,
I just can't change the Data folder nor the Tmp folder for the ASServer. There is no Browse-button like the Help tells you and the fields are grayed. The user is with Admin rights... I wonder if the reason is that the service is installed in a windows cluster
Ville
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply