November 16, 2010 at 3:59 am
Hi,
I'm trying to move the database location for and SQL2008 Cluster. I have set the default data and log file location to the new drive with no issue. However I am unable to move the existing database. I'm using the alter database method but they do not mount when I attempt to bring them back online.
I think the problem is with the folder security of my new location. The original location has permissions for MSSQLSERVER. I'm unable to find this to add it to the new location.
Any ideas?
Thanks,
Mark
December 22, 2010 at 9:03 pm
FYI, I finally got around to creating a connect item for the default data/log directories not be honored until service restart here.
I encourage everyone to read it, and to vote for it.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
December 25, 2010 at 2:24 pm
voted. That should be a no-brainer.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
October 5, 2011 at 8:35 pm
November 14, 2011 at 3:46 pm
so, if my instance is missing the following registry entries:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.2\MSSQLServer
DefaultData & DefaultLog
and i need to add these two entries on a cluster, do i need to reboot the machine or just restart sql services to take effect?
November 16, 2011 at 5:56 am
Just restart the SQL Services.
If you set the directories from the GUI, then those keys will be built for you.
When writing this article, I didn't consider clustered instances. They may go somewhere else... I'll try to find some time to investigate.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
Viewing 6 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply