Re: can ommiting log file speed up me and how Tarvirdi,
Set the database logging to simple and shrink it. I would consider 35GB to
be a medium size database. 500GB drives are in the $100 range according to
pricewatch.com.
Luke
"Tarvirdi" <mail@tarvirdi.com> wrote in message
news:eXabaVnfHHA.5044@TK2MSFTNGP05.phx.gbl...
> Dear friends,
> I have a database with simple stucture and tasks but big data sizes (23M
> rec, 35G data file).
> Most of my data are static and I dn't need transaction facilities. so I
> set it to simple mode.
> The log file is created and has good size. How can I get ride of it to
> have more simplified and
> more speed operations.
> Thanks
>
> |