Friday, February 17, 2012

Database data file does not auto-grow

Dear all,
We are using SQL2000 sp4 on Windows 2000 Svr.
We found one of the database size become zero in Enterprise manager.
We have checked the database setting and the database is already set
auto-growth, without limit, by 1000Mb each time.
The data file size reach 6G now.
Is there anything we miss? That's the first time we meet this case.
We have checked the Harddisk drive for the data file and it still have over
100G space.
IvanIvan wrote:
> Dear all,
> We are using SQL2000 sp4 on Windows 2000 Svr.
> We found one of the database size become zero in Enterprise manager.
> We have checked the database setting and the database is already set
> auto-growth, without limit, by 1000Mb each time.
> The data file size reach 6G now.
> Is there anything we miss? That's the first time we meet this case.
> We have checked the Harddisk drive for the data file and it still have ove
r
> 100G space.
> Ivan
Do you get an error message saying the filegroup is full?
What is the output of EXEC sp_spaceused?
Auto-growth is usually a bad idea and isn't something I would normally
recommend for a production application. Why would you want to grow a
6GB database in 1GB increments?
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||dbcc updateusage?
Cheers,
"Ivan" wrote:

> Dear all,
> We are using SQL2000 sp4 on Windows 2000 Svr.
> We found one of the database size become zero in Enterprise manager.
> We have checked the database setting and the database is already set
> auto-growth, without limit, by 1000Mb each time.
> The data file size reach 6G now.
> Is there anything we miss? That's the first time we meet this case.
> We have checked the Harddisk drive for the data file and it still have ove
r
> 100G space.
> Ivan
>
>

No comments:

Post a Comment