August 18, 2004 at 6:40 am
SQL Server 2000 running on Windows NT4 Server.
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 ?
August 18, 2004 at 7:14 am
Is the drive partitioned?
-SQLBill
August 18, 2004 at 7:47 am
Although the coincedence of 32GB makes me wonder. but I've passed that number on several occasions.
Sometimes I have noticed SQL will not create files if there is not enough Contigous space.
32g * .07 is 2.25g, with 18g free I would assume though, there is a chunk that big.
KlK
August 18, 2004 at 9:45 am
Just one NTFS Partition of 100Gb.
I am told the Disks are Raid 5, this means little to me.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply