NPR Report - Backup Convention & Strategy
Everybody has their own style, this is simple and works for me.
Original Report:
APP.DPM.zcus.report.name
Backup Copies:
APP.DPM.zcus.report.name.0
APP.DPM.zcus.report.name.1
APP.DPM.zcus.report.name.2
APP.DPM.zcus.report.name.3
Other backup conventions I've seen:
APP.DPM.zcus.report.name.bkp
APP.DPM.zcus.report.name.bkp.1
APP.DPM.zcus.report.name.20071201
APP.DPM.zcus.report.name.20071201.0700
Pick a convention that's simple and allows you to reliably restore a report when you need to. Using the .0,.1,.2,.3 strategy allows me to quickly select the last backup without doing any thinking should a restore of a report be needed. That's not a time, when I want to be wondering which one was the last one.

0 Comments:
Post a Comment
Links to this post:
Create a Link
<< Home