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

"Dylan Parry" <usenet@dylanparry.com> wrote in message
news:45d9e198$0$756$bed64819@news.gradwell.net...
> Greg D. Moore (Strider) wrote:
>
>> Handling which part? Changing it to simple?
>
> Yep.
>
>> Use Enterprise manager
>
> Enterprise Manager doesn't come with SQL Server 2005, and I'm finding
> the new tool to be pretty awkward to figure out.

Ah, my mistake I thought it you were on 2000. Yeah, I'm still learning the
new tools with 2005.

One VERY handy feature is the "create script" button so you can learn what
it's really doing under the GUI and if need be alter it or save it for
future use.)


>
>> Or the following query:
>>
>> alter database DBName set recovery simple
>
> Thanks, I'll do that.
>
> --
> 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 http://www.greenms.com

[Back to original message]