October 10, 2007 at 9:55 am
Our main database has a full backup ('with init') done once a week, and then a differential backup done once a day thereafter. In addition, the backup-device file is backed-up to an offsite machine once a day.
I've been asked if it's possible for the differential backups to be spread along sequential files (rather than laterally across adjacent files in a mediaset, as is the case in most of the examples in Books Online), so that when the offsite disk-backup occurs it only need backup one small differential backup per day rather than the one monolithic backup device containing the full backup and subsequent differentials.
Does anyone know whether this is possible? I can't think why it wouldn't be, but I've never heard nor read about it being done anywhere.
Thanks in advance.
October 10, 2007 at 10:01 am
yes, you can either create another backup device pointing to a different file for the differentials, or you can do backup to disk = 'full path' and it will write it out to the path you specify.
October 10, 2007 at 10:03 am
Simple as that? Cool, thanks again!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply