Must move Sql2000 AS data structure to a new disk location

  • 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

  • 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

  • Hi

    I'm trying to do this for Sql2000 Analysis Services (AS) database

    ...already executing my plan as I described

    Ville

  • 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

  • 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