recovery mode

[som...@js.com]

Hi, my database is simple recorvery model now, what's the good/bad things if
I swith to full? thanks...

[Linchi Shea]

Whatever answers you get here are no substitute for the detailed description
in the Books Online on this subject. I suggest you take a read there.

That said, with the full recovery mode, the most significant advantage is
that you can recover to a point in time if you back up your transaction log
regularly and preserve the log backups properly.

I guess the bad thing is that you need to manage your log backups.
Otherwise, you can blow up your transaction log easily.

Linchi

"som...@js.com" wrote:

> Hi, my database is simple recorvery model now, what's the good/bad things if
> I swith to full? thanks...
>
>

> .
>

[Jay]

If you don't manage your transaction logs, they will fill up your hard drive
and bring the database server down.

<som...@js.com> wrote in message
news:OLTrdbfa...@TK2MSFTNGP04.phx.gbl...

[som...@js.com]

Thanks Linchi,

If I siwth to full recovery, will slow down the production a bit?

"Linchi Shea" <Linch...@discussions.microsoft.com> wrote in message
news:62B5AA6A-9EB0-46F1...@microsoft.com...

[Jay]

> If I siwth to full recovery, will slow down the production a bit?

No. You will be required to do more maintenance though.

[Erland Sommarskog]

(som...@js.com) writes:
> Hi, my database is simple recorvery model now, what's the good/bad
> things if I swith to full? thanks...

Wrong question. The right question is: if the database goes belly-up
how much can you afford to lose? Is it OK to restore the most recent
backups (you are taking backups, aren't you?), or are you content with
losing recent updates? And this is not meant to be a rhethoric question,
but a real one that you need to ask yourself. Full recovery will help
you reduce data-loss in case of a disaster. But it comes with a cost, as
it incurs more management.

--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[som...@js.com]

Thanks Jay,

"Jay" <sp...@nospam.org> wrote in message
news:%23A4iuKg...@TK2MSFTNGP02.phx.gbl...

>
> > If I siwth to full recovery, will slow down the production a bit?
>
> No. You will be required to do more maintenance though.
>

If I swith to Full, can I still have one bak file or the log files are
separate?