Autogrow

I got this error a couple of times in the log this AM:
Error: 823, Severity: 24, State: 2
- and -
I/O error 38(Reached the end of the file.) detected during read at offset
0x00080009a3c000 in file 'D:\Data\Ramac_Data.MDF'..
BOL suggested a problem with the disk or disk full or file full. The disk
diags are fine; it is a 36GB disk with 30GB free space. I then look at the
properties of the database in question and see:
Size: 4018.94 MB
Space available: 0.00 MB
Ran DBCC CHECKDB, no errors found. Rebooted the server - still no change in
the above figures. I have Autogrow checked for both the DB file and the log
file, with unrestricted file growth for both and grow by set to 10 percent.
Why isn't it autogrow-ing?
Have you tried to manually grow it? Never rely on AutoGrow to do the work
for you.
Andrew J. Kelly SQL MVP
"Ron Hinds" <__NoSpam__ron@.__ramac__.com> wrote in message
news:ubB8Aw1TFHA.2940@.TK2MSFTNGP10.phx.gbl...
>I got this error a couple of times in the log this AM:
> Error: 823, Severity: 24, State: 2
> - and -
> I/O error 38(Reached the end of the file.) detected during read at offset
> 0x00080009a3c000 in file 'D:\Data\Ramac_Data.MDF'..
> BOL suggested a problem with the disk or disk full or file full. The disk
> diags are fine; it is a 36GB disk with 30GB free space. I then look at the
> properties of the database in question and see:
> Size: 4018.94 MB
> Space available: 0.00 MB
> Ran DBCC CHECKDB, no errors found. Rebooted the server - still no change
> in
> the above figures. I have Autogrow checked for both the DB file and the
> log
> file, with unrestricted file growth for both and grow by set to 10
> percent.
> Why isn't it autogrow-ing?
>
>
|||"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:Oxtmp35TFHA.3184@.TK2MSFTNGP15.phx.gbl...
> Have you tried to manually grow it? Never rely on AutoGrow to do the work
> for you.
OK... Can I at least rely on using Enterprise Manager to manually grow it?
Or should I stick to T-SQL exclusively?
[vbcol=seagreen]
> --
> Andrew J. Kelly SQL MVP
>
> "Ron Hinds" <__NoSpam__ron@.__ramac__.com> wrote in message
> news:ubB8Aw1TFHA.2940@.TK2MSFTNGP10.phx.gbl...
offset[vbcol=seagreen]
disk[vbcol=seagreen]
the
>