Posted by Greg D. Moore \(Strider\) on 02/19/07 16:22
"Dylan Parry" <usenet@dylanparry.com> wrote in message
news:45d9c2a0$0$763$bed64819@news.gradwell.net...
> Greg D. Moore (Strider) wrote:
>
> That's a good idea. Is it possible to simply *disable* the logs for a
> database? The reason being that as this is a development server I'm not
> remotely bothered about stats :)
Umm, logs have nothing to do with stats.
Logs are vital to disaster recovery and insuring ACID for your DB.
That said, for a DEVELOPMENT DB, you can use simple DB recovery which
truncates the log at the end of transactions. It doesn't prevent
transaction logging however.
>
> --
> Dylan Parry
> http://electricfreedom.org | http://webpageworkshop.co.uk
>
> Programming, n: A pastime similar to banging one's head
> against a wall, but with fewer opportunities for reward.
--
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com
[Back to original message]
|