Auto-Shrinking Problems

[tfierens]

Dear all,

One of our client is having a serious problem that is stopping him from processing his data and I am not quite sure what else to do at this stage.

The problem is that even though sql server 7.0 is suppose to auto-increase its size when the limit has been reached, it does not do that. (1) - How can I sort this out.

For the moment he increases the size manually which was fine, but there is one small (well rather large!!!) problem. Because the data is being entered at night and is entered extremely slowly, sql server shrink the database down, thus causing the application to generate a lot of errors. (2) Is there a way to stop auto-shrinking from occuring?

Many thanks

Regards,

Thierry

 

[schu]

In SQL 2000
in enterprise manager you can

Select database-><dbname>
right click on properties

you can control growth rates in &quot;data files&quot; tabs
and autoshrink in &quot;options&quot; tab