Posted by Greg D. Moore \(Strider\) on 02/19/07 17:25

--
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com

"Dylan Parry" <usenet@dylanparry.com> wrote in message
news:45d9d6a1$0$759$bed64819@news.gradwell.net...
> Greg D. Moore (Strider) wrote:
>
>> Umm, logs have nothing to do with stats.
>
> See, that's why I'm a noob :)
>
>> Logs are vital to disaster recovery and insuring ACID for your DB.
>
> Which I now understand!
>
>> 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.
>
> Ok. How do I go about handling this?

Handling which part? Changing it to simple?

Use Enterprise manager

Or the following query:

alter database DBName set recovery simple


>
> Cheers,
>
> --
> 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.

[Back to original message]