January 21, 2015 at 3:53 pm
Our SQL Server was installed in C:\ but all the system and user databases were in D:\. We had to move all databases on D:\ to a new drive G.
We moved our system databases (Master, model, MSDB) for SQL Server and user databases as per the instructions in MS knowledgebase articles. Everything went smooth, and SQL Server & Agent have been running smoothly on the new drives. My question is, how will this impact SSAS? What do I need to do for SSAS? I couldn't find any documentation on what changes I need to make to SSAS when a system databases are moved. Any help would be appreciated.
Thanks!
January 22, 2015 at 12:04 am
That would not affect SSAS at all as SSAS runs independently of the SQL Server engine.
You might want to also move the SSAS databases: http://blogs.msdn.com/b/karang/archive/2010/01/19/moving-data-directory-of-analysis-services-sql-2005-2008.aspx
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply