October 19, 2005 at 7:42 am
Hi
I've been playing around with Analysis Services for a couple of weeks and I've made a bit of a boo-boo.. I've not backed up my AS databases and now the worst has happened, hardware failure on my PC...
I've got a copy of my C drive with all the data on it and I've installed AS onto another machine, but I can't see any way of 'attaching' the AS Databases I've created. There are no CAB files to restore from
Any ideas would be appreciated
October 20, 2005 at 12:13 am
You may be OK, depends on a few variables.
Did you have your Repository in SQL Server or did you leave it in MSAccess? If you don't know, then it's probably still in access. You could try the following:
- Backup (ie copy/paste) your existing MSAccess repository (just in case, but assuming you've not
created anything new, this is a redundant step).
- Stop your analysis services service
- copy your old repository to where your current repository resides.
- copy the entire contents of your old 'data' directory for Analysis Services and paste over your current directory. The default location for this is 'C:\Program Files\Microsoft Analysis Services\Data'
- try to restart the service.
if all went well, you will have just replaced the repository (this is the metadata describing what's in the data directory) and also the data (ie what's in the data directory, ie cubes and dimensions).
Good luck, let us know how it pans out. If you did actually move your repository to SQL, then it's basically the same thing, but take the MDF (sql data file, and ldf, sql log file) attach them to your new install of MSSQL, stop the AS service first(!!), copy the data across and then restart the service again.
Steve.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply