SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Disparate sector size when log shipping from ESX to AHV


Disparate sector size when log shipping from ESX to AHV

Author
Message
theflyingdba
theflyingdba
SSC Veteran
SSC Veteran (219 reputation)SSC Veteran (219 reputation)SSC Veteran (219 reputation)SSC Veteran (219 reputation)SSC Veteran (219 reputation)SSC Veteran (219 reputation)SSC Veteran (219 reputation)SSC Veteran (219 reputation)

Group: General Forum Members
Points: 219 Visits: 436
All,
We have an issue that has surfaced since moving from ESX to AHV as our hypervisor, where in we are seeing an IO mismatch between the new 4096 (secondary) and old 512 (primary) log shipping servers. We get several 9004 errors daily and end up removing the log shipping and re-implementing. The secondary site has the log shipped database in Standby, read only mode.

Now, I understand that this would cause the issue and depending upon your version of SQL Server there have been hotfixes / Cu's that address this, along with either trace flag 1800 or 3057.

https://support.microsoft.com/en-us/help/2987585/restore-log-with-standby-mode-on-an-advanced-format-disk-may-cause-a-9


The question I have is, that MS only released the hotfix for SQL 2008 R2 SP2... and we are running with SQL 2008 R2 SP3... which obviously has all the Cu's from between the 2 versions, but does this include the hotfix? I cannot seem to find information on this anywhere... and only details relating to the CU's.

If this is not part of SP3, is it possible, with no detrimental affects, to install this hotfix onto SP3, even though it was released for SP2 and would it actually have an affect in this case?

Thanks all...

Principal SQL Server DBA and SME for a large, global organization.
IN: https://uk.linkedin.com/in/hadenkingslandseniordba
theflyingdba
theflyingdba
SSC Veteran
SSC Veteran (219 reputation)SSC Veteran (219 reputation)SSC Veteran (219 reputation)SSC Veteran (219 reputation)SSC Veteran (219 reputation)SSC Veteran (219 reputation)SSC Veteran (219 reputation)SSC Veteran (219 reputation)

Group: General Forum Members
Points: 219 Visits: 436
So, finally solved (well worked around this issue)

After a lot of back and forth to MS, we agreed to apply the on demand hotfix 3033860 for SQL 2008 R2 SP3 and then turn on trace flag 3057.

The moral of this story being... be very aware of what is taking place in your environment, not just for SQL Server. This is something I try to do on a daily basis, but in this instance I had no sight or awareness of the hypervisor move. Hopefully you will be a little better placed now if this ever happens to you. Although, come mid 2019, non of us will be running SQL 2008 R2 right? Wink

Principal SQL Server DBA and SME for a large, global organization.
IN: https://uk.linkedin.com/in/hadenkingslandseniordba
theflyingdba
theflyingdba
SSC Veteran
SSC Veteran (219 reputation)SSC Veteran (219 reputation)SSC Veteran (219 reputation)SSC Veteran (219 reputation)SSC Veteran (219 reputation)SSC Veteran (219 reputation)SSC Veteran (219 reputation)SSC Veteran (219 reputation)

Group: General Forum Members
Points: 219 Visits: 436
I spoke too soon... the issue has re-occurred even after the hotfix and trace flag.... open to ideas?

Principal SQL Server DBA and SME for a large, global organization.
IN: https://uk.linkedin.com/in/hadenkingslandseniordba
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search