SQL Server 2000 running on Windows NT4 Server, Database Data File on a disk
with a single NTFS Partition of 100Gb.
We have a database with the data file set to auto grow by 7% with
unrestricted file growth.
At the point that it reached 32Gb it ceased to auto grow, updates, inserts
were failing. There is 18GB free on the disk on which the associated data
file resides.
In the end we just associated another data file with the database because we
couldn't work out what was going on.
Anyone have any suggestions ?
If you increase the size of the data file manually with "alter database
modify file" command, does the file grow and consume the 18GB of free disk
space?
Wei Xiao
SQL Server Storage Engine Development
This posting is provided "AS IS" with no warranties, and confers no rights.
"Barry Shapiro" <BarryShapiro@.discussions.microsoft.com> wrote in message
news:8B63956F-86B8-470F-8388-015A140AE85C@.microsoft.com...
> SQL Server 2000 running on Windows NT4 Server, Database Data File on a
disk
> with a single NTFS Partition of 100Gb.
> We have a database with the data file set to auto grow by 7% with
> unrestricted file growth.
> At the point that it reached 32Gb it ceased to auto grow, updates, inserts
> were failing. There is 18GB free on the disk on which the associated data
> file resides.
> In the end we just associated another data file with the database because
we
> couldn't work out what was going on.
> Anyone have any suggestions ?
>
|||Check SQL Server error log to see if the 'auto grow' is resulting in any
errors. Can you post those errors here, if you see any?
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Barry Shapiro" <BarryShapiro@.discussions.microsoft.com> wrote in message
news:8B63956F-86B8-470F-8388-015A140AE85C@.microsoft.com...
SQL Server 2000 running on Windows NT4 Server, Database Data File on a disk
with a single NTFS Partition of 100Gb.
We have a database with the data file set to auto grow by 7% with
unrestricted file growth.
At the point that it reached 32Gb it ceased to auto grow, updates, inserts
were failing. There is 18GB free on the disk on which the associated data
file resides.
In the end we just associated another data file with the database because we
couldn't work out what was going on.
Anyone have any suggestions ?
|||Hello
This could be because the amount of space that autogrow needs to grow the
file by is large enough that the request times out while the newly
allocated portion of the file is still being zeroed out. Change the 7% to
500MB (from database file properties window in Enterprise Manager) and
check if autogrow works again.
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
