June 1, 2012 at 3:45 am
Hi All
I have a requirement to create a copy of two databases to which there is not enough space on the node where they are hosted, not a problem I said, Instance 3 has enough space, you will just need to change your connection strings, no problem with the developers on that.
The issue is that when I tried to create the databases the drive in question hasn't been added as a dependency for the SQL instance to start, so SQL obviously wont create the DB. Adding the drive as a dependency isnt a problem, but as I have only ever used 2003 clusters before you had to take the group offline, I know you dont need to do that in 2008, but the question is, will SQL automatically see the new drive as a dependency to the instance, or will I need to cycle the instance to pick up the drive to be able to create the DB's?
Cheers in advance
June 1, 2012 at 4:50 am
Don't know offhand, but just open up the restore window and try to locate the new drive, if it doesn't like it it will soon let you know.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 1, 2012 at 4:54 am
Thanks Perry, I think it will be a try it and find out job. Trying to not restart the instance if I can, as we are a 24/7 operation and downtime needs to be approved 4 weeks in advance, but as its an urgent requirement they might let it go.
Will update when I have the answer.
June 1, 2012 at 5:37 am
For reference, adding the drive as a dependency didn't require SQL to be restarted before showing the drive, all done online with no issues.
June 1, 2012 at 12:07 pm
You responded to yourself before I could. But yea, in my 2008 R2 cluster (windows and sql), we've added several drives to live prod nodes without issue.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply