Log shipping with simple recovery model?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DBA - 31 Dec 2008 17:21 GMT

We have a vendor that is recommending that if we want to do log shipping, we
should set the db for simple recovery model. Anyone ever heard if that is
possible? The only thing that I have seen or read about, it must be either in
full or bulk-logged models.

Reply to this Message

Rick Sawtell - 31 Dec 2008 17:49 GMT

> We have a vendor that is recommending that if we want to do log shipping,
> we
> should set the db for simple recovery model. Anyone ever heard if that is
> possible? The only thing that I have seen or read about, it must be either
> in
> full or bulk-logged models.

I'm fairly certain that that is not possible. In simple recovery mode, the
inactive portion of the log is cleared every time a checkpoint is executed.
When you perform a backup, one of the first steps is a checkpoint. This is
why you cannot perform a log backup of a database in simple mode. There is
nothing to back up.

Just my .02

Rick Sawtell

Reply to this Message

Kalen Delaney - 31 Dec 2008 20:05 GMT

This is absolutely not possible. Log shipping ships transaction log backups,
if and you are in SIMPLE recovery, log backups cannot be made, so there will
never be anything to ship.

Maybe you should tell us who this vendor is? Are they actually making
software to run on SQL Server?

:-)

Signature

HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
www.SQLTuners.com

Reply to this Message