Weekly Full, Daily Log, Monthly Full. Is it possible ?

[DavrosDalek]

Hi
Looking for some advise here please.
We currently run weekly full sql backups and daily log backups these are bound to a management class that gives a rolling 35 day retention.
In addition we run a monthy full backups that keep those backups for a rolling 7 years (finatial stuff)
We currently have two nodes per server to do this.
Is it possible in some way to have this same ability to roll back over the latest 35 days but to also be able to roll back to the month end backups over the past 7 years using just one node ?
Cheers
DD

 

[GregE]

No, these two nodes have no recognition of one another. And transaction log backups should only be done to under one node, which means they can only be restored to that one node. You never want multiple anything (different products, or different TSM nodes, etc) doing transaction log backups of the same database.

I posted something on this some time ago with a detailed test scenario, but I can't locate it.