Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-09-02 : 06:53:00
|
| peter writes "My question is regarding the autogrow function.We currently have one database which will not autogrow ( it is set on).The database is 1.7GB so its not that big.The only other reference to this I have found can be read at the folowing urlhttp://dbforums.com/arch/70/2002/4/340928Do you know of ant problems with autogrow, or can you suggest any parameters i can check for this db?I have created a test db on the same server and populated it and the autogrow functions kicks in and increases the size with no problems.Any pointers would be appreciated.RegardsPeter Dunnsql 2000 (build 2195: sp3)windows 2000 sp3" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-02 : 12:31:19
|
| The problem would be that when the file needs to grow, performance will be negatively impacted. But what happens if the file needs to grow and now it can't because the autogrow isn't set? Well, users aren't going to be able to use the database. The problems listed in the article that you referenced have to do with SQL Server 7.0.Tara |
 |
|
|
|
|
|
database autogrow