Hi Ronald,
My question is - to have this working you will not have your primary
database enabled for log-shipped (so that DPM can take incrementals) ?
If I understand correctly it seems this might work for you - where in you
seed the secondary server and then restore logs to the secondary server from
DPM as they get backed up by DPM from the primary database. DPM does not
provide a recovery mechanism to restore only logs. So you might have to
write scripts to pick the logs backed up and then manually restore them to
the secondary server.
But I feel you might not get any guarantees that SQL inherently provides for
log-shipping as a high availability feature.
Hope this answers your question,
Hitesh Sharma [MSFT]
This posting is provided "AS IS" with no warranties, and
confers no rights.
Use of included script samples are subject to the terms
specified at http://www.microsoft.com/info/cpyright.htm
Post by Ronald GreenHi Hitesh,
Thanks for your response.
I understand all this.
Now my question is whether I can leverage DPM with scripts to have
both the express full backups and the log backups taken by DPM, and
restore them to another server (with script) - and so enjoy both
worlds - have a log shipped secondary server, and have the log backups
saved within DPM.
Your help is most appreciated!
Thanks,
R. Green
Post by Hitesh Sharma [MSFT]Hi Ronald,
DPM detects a log shipping database and will disable the option to take
incremental backups (read Log backups). This way you can rest assured that
DPM wont break log chain sequences. But this holds true only if Log shipping
is enabled for the database before protection begins. If Log shipping is
enabled for a database protected by DPM, DPM wont detect log-shipping and
will continue with incremental backups which will eventually break log chain
sequence. So in short, DPM detects Logshipping only during the first time
protection flow.
So DPM can be used to take only express full backups for log-shipped
databases.
Hope this helps,
Hitesh Sharma [MSFT]
This posting is provided "AS IS" with no warranties, and
confers no rights.
Use of included script samples are subject to the terms
specified athttp://www.microsoft.com/info/cpyright.htm
Post by Ronald GreenAnyone??
Post by Ronald GreenHi,
As far as I know, if I want to protect a log shipped database you may
only use DPM to take express full backups. Otherwise, you log backup
chain will be broken.
Is this right?
Now, if I want to centralize my backups and still do log shipping, is
1. Take express full backups of primary
2. Take log backups of primary
3. Restore (manually...) the express full backup to a secondary server
4. Write a PowerShell script to restore log backups onto secondary
server
Is it possible?
Cheers,
R. Green