吐槽EMC.NW for MS 模块在备份AG中的数据库时候不能执行diff备份

图片压缩得太厉害了，里面啥内容都看不清。

另外看了下文档，NMM好像真不支持differential backup level，无论是VDI还是VSS：

https://support.emc.com/docu61063_NetWorker-Module-for-Microsoft-for-SQL-VDI-Release-9.0-User-Guide.pdf?language=en_US

https://support.emc.com/docu61062_NetWorker-Module-for-Microsoft-for-SQL-and-SharePoint-VSS-Release-9.0-User-Guide.pdf?l…

尽量用其他办法把...

dear :

  我用sqlserver2014使用NW只选择primary上的主机好像成功嘞。

BACKUP database [LGCPSC] TO virtual_device='Legato#d9aa3d14-cc7c-495b-8634-f0727a94f7f6' WITH name=N'LegatoNWMSQL', description=N'MSSQL#SPC_AG:LGCPSC', COMPRESSION, maxtransfersize = 4194304

BACKUP database [LGC_EZUMS_HMI_1] TO virtual_device='Legato#6c06350b-ca58-462c-accd-e8f7b8e426bf' WITH name=N'LegatoNWMSQL', description=N'MSSQL#SPC_AG:LGC_EZUMS_HMI_1', COMPRESSION, maxtransfersize = 4194304

BACKUP database [SPC_DEV] TO virtual_device='Legato#8608da1c-aa3b-4d2d-ab07-b1ce67221611' WITH name=N'LegatoNWMSQL', description=N'MSSQL#SPC_AG:SPC_DEV', COMPRESSION ,differential, maxtransfersize = 4194304

BACKUP database [SPC_DEV] TO virtual_device='Legato#8608da1c-aa3b-4d2d-ab07-b1ce67221611' WITH name=N'LegatoNWMSQL', description=N'MSSQL#SPC_AG:SPC_DEV', COMPRESSION ,differential, maxtransfersize = 4194304

BACKUP database [LGC_EZUMS_HMI_1] TO virtual_device='Legato#6c06350b-ca58-462c-accd-e8f7b8e426bf' WITH name=N'LegatoNWMSQL', description=N'MSSQL#SPC_AG:LGC_EZUMS_HMI_1', COMPRESSION, maxtransfersize = 4194304

不过只有在2014上测试过2012还没有。

Dear ：一切真相大白了。

BACKUP database [LGCPSC] TO virtual_device='Legato#45f35ef6-930e-4324-ab4d-ab6ebcc5e4e0', virtual_device='Legato#45f35ef6-930e-4324-ab4d-ab6ebcc5e4e0_2',

virtual_device='Legato#45f35ef6-930e-4324-ab4d-ab6ebcc5e4e0_3', virtual_device='Legato#45f35ef6-930e-4324-ab4d-ab6ebcc5e4e0_4' WITH name=N'LegatoNWMSQL',

description=N'MSSQL#SPC_AG:LGCPSC' ,differential, maxtransfersize = 4194304

BACKUP database [LGC_ezControl_HMI_1] TO virtual_device='Legato#b9167b1d-df3b-4d11-9a1c-9113ec133c57', virtual_device='Legato#b9167b1d-df3b-4d11-9a1c-

9113ec133c57_2', virtual_device='Legato#b9167b1d-df3b-4d11-9a1c-9113ec133c57_3', virtual_device='Legato#b9167b1d-df3b-4d11-9a1c-9113ec133c57_4' WITH

name=N'LegatoNWMSQL', description=N'MSSQL#SPC_AG:LGC_ezControl_HMI_1' ,differential, maxtransfersize = 4194304

BACKUP database [SPC_DEV] TO virtual_device='Legato#bef37b53-b829-4655-9d28-095e589280e5', virtual_device='Legato#bef37b53-b829-4655-9d28-095e589280e5_2',

virtual_device='Legato#bef37b53-b829-4655-9d28-095e589280e5_3', virtual_device='Legato#bef37b53-b829-4655-9d28-095e589280e5_4' WITH name=N'LegatoNWMSQL',

description=N'MSSQL#SPC_AG:SPC_DEV' ,differential, maxtransfersize = 4194304

BACKUP database [LGC_EZUMS_HMI_1] TO virtual_device='Legato#c6500912-3cbf-4877-8105-8c63c17b02f2', virtual_device='Legato#c6500912-3cbf-4877-8105-

8c63c17b02f2_2', virtual_device='Legato#c6500912-3cbf-4877-8105-8c63c17b02f2_3', virtual_device='Legato#c6500912-3cbf-4877-8105-8c63c17b02f2_4' WITH

name=N'LegatoNWMSQL', description=N'MSSQL#SPC_AG:LGC_EZUMS_HMI_1' ,differential, maxtransfersize = 4194304

只要链接的是primary node中的数据库且MSSQL设置是backup on primary的就可以实现diff备份但如果选择的是secondary的readonly node就甭想了。 不知道NW为啥这么设计？

yes ,you are right

哎 一开始以为是备份软件设计缺陷没想到真的是MS的限制，我打电话给了客户在韩国的微软工程师，对方说 由于always on的secondary是read only 如果已经enable那么secondary的数据库就必需copy_only 因此也没有backup chain所以没有diff备份，

在这里像被我电话打爆的support工程师们致歉