November 11, 2015 at 10:12 am
Guys, just confirming that there would be no issue in shutting down SQL services on 2 AlwaysOn nodes (primary & secondary), moving the database files to another drive, renaming the drive to the same name as the old one so the dbs will all have the same paths once SQL services are started back up. I believe that works no problem on a regular instance but curious if there are extra considerations if they are clustered HA?
November 11, 2015 at 2:45 pm
I just had to do this after a volume failure.
No issues. I would manually stop the data transfers first.
November 12, 2015 at 4:23 am
As Krypto said make sure you stop the data transfers.
Also make sure that all permissions are matched through the folder structure.
November 12, 2015 at 8:48 am
When you guys mean data transfer, that's from the application end correct?
November 12, 2015 at 8:57 am
chrisph (11/12/2015)
When you guys mean data transfer, that's from the application end correct?
No...drill down into High Availability - then drill down into 'Availability Databases' then right click and 'suspend data movement' on all the DB's.
This causes the logs to harden on the listener server. So you won't get out of sync errors when you reconnect everything.
If all you doing is a direct copy of the data - permissions should be unchanged. BUt to grasshoppers point - permissions can be a bitch when failing over to the listener.
November 12, 2015 at 9:13 am
Great, thanks!
November 12, 2015 at 9:29 am
Np.
November 13, 2015 at 4:07 am
krypto69 (11/12/2015)
then right click and 'suspend data movement' on all the DB's.
Just suspend data movement on the primary and that will be enough
krypto69 (11/12/2015)
If all you doing is a direct copy of the data - permissions should be unchanged.
If you're copying to a new volume you will need to set folder level NTFS ACLs
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply