February 11, 2014 at 8:39 am
trying to find out if this is the best way to move log files in databases that are in an availability group.
remove the DB from the AG
Run alter database commands like you would normally to take offline ,move file,bring online ,etc
drop the db from secondary node
then rejoin the DB to the AG
is that the only option for moving them when its in an avail group? cant find any other info on moving files in mirrors or HA groups
February 11, 2014 at 9:56 am
That sure would seem to be the process to me also, but like you I don't know that that is documented explicitly anywhere. Edge cases like that usually don't get covered.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
February 12, 2014 at 4:48 am
newbie_DBA (2/11/2014)
trying to find out if this is the best way to move log files in databases that are in an availability group.remove the DB from the AG
Run alter database commands like you would normally to take offline ,move file,bring online ,etc
drop the db from secondary node
then rejoin the DB to the AG
is that the only option for moving them when its in an avail group? cant find any other info on moving files in mirrors or HA groups
From what i can understand you want to move the primary dbs log file and then reflect this in the secondaries, correct?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply