dbTalk Databases Forums  

AS2000 - Moving the Data folder

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss AS2000 - Moving the Data folder in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jesse O
 
Posts: n/a

Default AS2000 - Moving the Data folder - 11-14-2005 , 11:19 AM






I'd like to move my data folder. What are the proper steps to doing this? I
know there's a property in the UI to change the location, however that's
grayed out. Also, are any reg settings needed to be changed? Does it require
a reboot or just a restart of the service?

Thank you!



Reply With Quote
  #2  
Old   
Darren Gosbell
 
Posts: n/a

Default Re: AS2000 - Moving the Data folder - 11-14-2005 , 06:09 PM






The data folder can only be changed in Analysis Manager if you run it on
the server itself. You will need to restart the service after you change
this setting. For as little downtime as possible you can copy the data
folder to its new location first. Then change the setting and stop and
start the service. Once you have confirmed that all the cubes are
operational you can delete the original data folder.

Of course it is a good idea to make sure you have current backups before
doing this - just in case.

HTH

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <#g0Hb#T6FHA.2560 (AT) TK2MSFTNGP12 (DOT) phx.gbl>, jesperzz (AT) hotmail (DOT) com
says...
Quote:
I'd like to move my data folder. What are the proper steps to doing this? I
know there's a property in the UI to change the location, however that's
grayed out. Also, are any reg settings needed to be changed? Does it require
a reboot or just a restart of the service?

Thank you!




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.