question

kartheeksuresh avatar image
kartheeksuresh asked

Log Shipping: Full backup on Secondary Database

Hi, I have configured log shpping and my secondary database is in read-only mode, Now I would like to take a full and differential backups of my secondary databases. Could you please let me know whether I can take full and differential backups on my secondary database on regular basis or nor?
log-shippingfullsecondary
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Cyborg avatar image
Cyborg answered
Secondary database cannot be backed-up in logshipping, for t-log backups you can relay on your primary server which ships log backups to your "Copy\Destination folder".
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.