July 11, 2005 at 6:39 am
We have a 64-bit HP Superdome with SQL SERVER 2000 installed on it. I accidentally deleted OLAPQueryLog and OLAPRepository databases which are necessary for OLAP Analysis Services to run. We don't have yet OLAP databases in production, but we are going to have soon. There is no option to uninstall only Analysis Services in 64-bit SQL Server 2000 and install them again. It is not possible to uninstall the whole instance, because there are live databases running. Is it safe to restore those two databases from another 64-bit installation ;
Thanks in advance
Petros Andrikopoulos
July 11, 2005 at 8:11 am
Firstly, I've not done this on a 64bit server, hey, i haven't done this on a 32 bit machine either. But, from info gleaned from the Ops Guide (thanks Dvae Wickert!) I would have though that doing the following would get you back to a stable position:
1. Create/restore OLAPRepository (and the log) to your SQL server that nornally hosts these (most people use the same machine)
2. Delete (rename or move would maybe be safer) the contents of the data directory (you may need to stop the service to do this?)
3. Restore a copy ofthe catalogs from another server back to this server.
Things that I would be doing prior to the above-listed steps:
1. Look for a recent backup of my repository (you back them up everynight yeah?!?), restore it.
2. Call PSS in caase they have an official method for trying to do this.
3. Talk to my DBA people who may be able to restore the DB from transaction logs???? Is a 'DROP DATABASE' call logged???
You really need to stop for a few minutes (like 60) and see what options are available and then take you pick from the least offensive ones.
Hope it works out for you.
Steve.
July 11, 2005 at 8:19 am
Steve,
thanks for helping with this issue.
Petros
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply