|
Home > Archive > MS SQL Server > October 2006 > Database data file does not auto-grow
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
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.
Ivan
| |
| David Portas 2006-10-24, 6:38 pm |
| 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 over
> 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
--
| |
| soonyu 2006-10-24, 6:38 pm |
| 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 over
> 100G space.
>
> Ivan
>
>
>
|
|
|
|
|