Full Recovery

I have a production DB that is in Simple recovery mode. I want to change it
to Full Recovery mode. Are there any settings that i should change before
switching such as from MULTI to SINGLE_USER mode. Will this affect the
current maintenance plans, backup jobs that i have currently running? The
bottomline is that "is it as simple as changing it to Full recovery in
database properties? Thanks...
mmc wrote:
> I have a production DB that is in Simple recovery mode. I want to change it
> to Full Recovery mode. Are there any settings that i should change before
> switching such as from MULTI to SINGLE_USER mode. Will this affect the
> current maintenance plans, backup jobs that i have currently running? The
> bottomline is that "is it as simple as changing it to Full recovery in
> database properties? Thanks...
You'll need to schedule periodic transaction log backups, otherwise the
transaction log will never get flushed out and will continue to grow as
new transactions are created.
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||Could the log growth be handled by creating a "Shrinkfile" or "Shrinkdb" job?
"Tracy McKibben" wrote:

> mmc wrote:
> You'll need to schedule periodic transaction log backups, otherwise the
> transaction log will never get flushed out and will continue to grow as
> new transactions are created.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>
|||mmc wrote:
> Could the log growth be handled by creating a "Shrinkfile" or "Shrinkdb" job?
>
Nope. Shrinking removes free space from the files, it doesn't remove
committed transactions. Backing up the log file will remove the
committed transactions.
Tracy McKibben
MCDBA
http://www.realsqlguy.com