Problems with large DB file sizes?

Hi,
One of my colleagues has expressed reservations about having MSS-2000 data files grow bigger than 10-GB. He's seen fatal errors (#823 & #723) on a sporadic basis when the file sizes are generally larger (10-20GB each file). CHKDSK shows no media corruptio
n and a reboot of the MSS-2000 server and/or Windows server does the trick.
I know this is probably not much to go on ... but the question is ... has anyone seen or written any recommendations on how big the file sizes should be based on some technical merits?
TIA
-aa
Haven't seen any problems with mine, hardware problem but no Sql2k problem.
Mine is at 16gig and i just shrunk it.
jc
"AA" <anonymous@.discussions.microsoft.com> wrote in message
news:47BBBFBA-A09E-40FB-A659-41D259350BC1@.microsoft.com...
> Hi,
> One of my colleagues has expressed reservations about having MSS-2000 data
> files grow bigger than 10-GB. He's seen fatal errors (#823 & #723) on a
> sporadic basis when the file sizes are generally larger (10-20GB each
> file). CHKDSK shows no media corruption and a reboot of the MSS-2000
> server and/or Windows server does the trick.
> I know this is probably not much to go on ... but the question is ... has
> anyone seen or written any recommendations on how big the file sizes
> should be based on some technical merits?
> TIA
> -aa
|||Thx John