coolchaitu
SSChampion
Points: 10334
More actions
November 8, 2015 at 8:16 am
#399294
Good morning Everyone,
In mirroring, if i issue DBCC shrinkfile command on the principal database, will it physically shrink the file in the mirrored database also?
george sibbald
SSC Guru
Points: 104210
November 9, 2015 at 6:38 am
#1838534
every command you issue against the principal will be reflected on the mirror, including shrink commands
---------------------------------------------------------------------
November 9, 2015 at 6:50 am
#1838539
Good morning George,
Thanks a lot for replying. So, it will physically shrink the file in the mirrored database also?
November 9, 2015 at 6:53 am
#1838540
yes
November 9, 2015 at 7:18 am
#1838551
Thanks George
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply