Posted by Andrea Montanari on 05/11/06 12:32

hi,
XNMB wrote:
> SQL2K5 SP1
>
> the autogrowth setting in one of my database's primary filegroup data
> file keeps having the value of 12800%, which was originally set to
> 100MB, everytime the service is restarted. the same occurs whenever i
> restore a backup of this database in our development environment.
>
> WTF? this issue does not happen to other filegroups. only on the
> primary data file. whenever this happens the 4GB data file grows to
> more than 70GB (even the math is incorrect) with about 95% of UNUSED
> space.
>
> has anyone else come accross this BS or anyone knows how to prevent
> this from happening? is MS aware of this not-so-funny joke?
>

unfortunately, it's a bug, already reported as you can see at
http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=4369ed03-a43f-4fb5-9962-729b178a7fa0
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

• Next in forum: Re: how to create a real (not virtual) table from view1 & view2 ni sql server?
• Prev in forum: bug: data file autogrowth set to 12800%
• Thread view: Re: data file autogrowth set to 12800%

[Reply to this message]