April 4, 2017 at 10:24 am
Hi Experts
I am new to SSAS. have to copy the SSAS db from production to non-production without downtime. can you please give steps how to perform this?
Thanks
Shuaib
April 4, 2017 at 12:07 pm
If I am not mistaken, the SSAS Database is just another database. The stuff it does on the back end is the interesting side.
But if you just need to move the DB from live to test, I'd do a backup and a restore. That's likely the easiest way to do it with no downtime.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 4, 2017 at 2:33 pm
After restoring the SSAS database, just make sure you repoint your Data Sources, so that the cube will use your testing SQL Server database not your production SQL Server databases.
April 4, 2017 at 2:48 pm
bmg002 - Tuesday, April 4, 2017 12:07 PMIf I am not mistaken, the SSAS Database is just another database. The stuff it does on the back end is the interesting side.
But if you just need to move the DB from live to test, I'd do a backup and a restore. That's likely the easiest way to do it with no downtime.
Thank you. Backup And Restored Worked.
April 4, 2017 at 2:48 pm
Chris Harshman - Tuesday, April 4, 2017 2:33 PMAfter restoring the SSAS database, just make sure you repoint your Data Sources, so that the cube will use your testing SQL Server database not your production SQL Server databases.
Thank you for pointing this out.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply