Yes AUTO close is off.

Yes, I have a SSIS packages that does backups to that drive and folder. If the backup process locks that folder why would it not...

Thanks John that's an interesting point. The disk is shared with a read only copy of our production db(the one we've been discussing) that gets restored every early morning...

Thanks Ninja. So as you and John suggested the final settings on SQL 2000

...

Ninja, I don't want them to grow bad just trying to understand if the 3% is even revelant at this time given the free space. Some literature suggest never...

So in effect then data and log files are not growing because they have so much free space and the 3% growht is not revelant at the time.

Thanks Ninja. Yes it's SQL 2000. So everyone would suggest that I change from percent to file growth in megabytes(500-2000_ but autogrowth would still be on.

I just need to understand one point. If I have free space = 99% or 40% doesn't that free space have to be consumed(or show as being reduced) before...

Thanks John. Given the free space in the files should 1% auto be ample? Isn't this forcing the free space in each file to be used? Can...

--drop table @temp

declare @temp table(tag smallint primary key)

insert into @temp(tag)

values(1)

insert into @temp(tag)

values(2)

insert into @temp(tag)

values(3)

insert into @temp(tag)

values(4)

insert into @temp(tag)

values(5)

insert into @temp(tag)

values(6)

insert into @temp(tag)

values(7)

insert into @temp(tag)

values(8)

insert into @temp(tag)

values(9)

insert into @temp(tag)

values(10)

--2 records

--Time 0...