Autogrow 'is_percent' flag set on principal does not persist to mirror - by Matthew Gantz

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 796354 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 8/5/2013 10:41:39 AM
Access Restriction Public


I am changing the autogrow settings on the principal server to grow by a fixed amount. When the mirror database is made into the principal via manual failover, the autogrow settings do not completely move to the new server.

The 'growth' value does move, but the 'is_percent' flag does not. This results in a autogrow setting of 32768% when 256MB fixed growth is specified. 
Sign in to post a comment.
Posted by Microsoft on 11/12/2013 at 2:54 PM
Thanks for reporting his issue. This has been addressed in a cumulative update for SQL Server 2008 R2.

Please see for more information.

Ajay Jagannathan
Senior Program Manager