Log shipping and running backups

[GiJeet]

Hello, on SQL2K8 when setting up log shipping there is a Note on one
of the screens that says you can't take backups of the primary
database once log shipping is running. What's with this? We wish to
setup log shipping, we haven't yet, and we also have a development
environment where we will need the production db restored once in
awhile. I don't want to be prevented from running full db backups on
the primary once we setup log shipping. Does anyone know anything
about this? Thanks!

G

[Ben Thul]

I think the statement is that you can't take full backups until you're
able to restore it to your log shipping destination and get it caught
up. The reason being is that once you take another full database
backup, subsequent log backups are based on that new full backup
rather than the one that you planned on using to establish log
shipping. I say give it a shot in your dev environment and see what
happens.
--
Ben

Post by GiJeet
Hello, on SQL2K8 when setting up log shipping there is a Note on one
of the screens that says you can't take backups of the primary
database once log shipping is running.  What's with this?  We wish to
setup log shipping, we haven't yet, and we also have a development
environment where we will need the production db restored once in
awhile.  I don't want to be prevented from running full db backups on
the primary once we setup log shipping.  Does anyone know anything
about this?  Thanks!
G