Is the size of data.mdf too large? it is about 8G

Hi All
I have a question about size of data file.
My database have two data file :
data.mdf is 8G
log.ldf is 400M.
Is the size of data.mdf too large ?
Recently our database is often corrupted. Such as page
errors. I think the cause maybe is size of data.mdf is too
large. So it can cause the file corrupted?
Do I think right?
Last evening the database is corrupted and can not
be repaired by running DBCC command. So the only thing I
can do is restore the database from latest backup.
Is the size of data.mdf too large?
Any help is appreciate.
Thanks
Ping8GB is not large at all for sql server. If your getting corruption it is
most likely due to the hardware. Do you have a proper RAID with a battery
backed controller for the data file and is the server on a UPS?
--
Andrew J. Kelly
SQL Server MVP
"pingc@.elibrium.com" <chenpingnet@.hotmail.com> wrote in message
news:2a02b01c391e3$60679270$a601280a@.phx.gbl...
> Hi All
> I have a question about size of data file.
> My database have two data file :
> data.mdf is 8G
> log.ldf is 400M.
> Is the size of data.mdf too large ?
> Recently our database is often corrupted. Such as page
> errors. I think the cause maybe is size of data.mdf is too
> large. So it can cause the file corrupted?
> Do I think right?
> Last evening the database is corrupted and can not
> be repaired by running DBCC command. So the only thing I
> can do is restore the database from latest backup.
> Is the size of data.mdf too large?
> Any help is appreciate.
> Thanks
> Ping
>