What are the challenges you face when working across database platforms? Take the survey
Options

No option for data mirroring in scheduled task?

MindfluxMindflux Posts: 47
edited August 22, 2006 1:53PM in SQL Backup Previous Versions
I want to have my tlog backups mirrored in real time. However it doesn't seem that the SQL Backup software does it? Does the Pro edition?

I know I can have the log back up hourly.. I do that now. But I wanted to check out the redgate backup so I could tell it to mirror my backups to external media as WELL as the raid array it currently backs up to.

Am I doing something wrong or is this feature not availible (for both database backup and t-logs).

I see you can do it through the backup wizard (just not a scheduled task)?

Comments

  • Options
    peteypetey Posts: 2,358 New member
    It is possible, though you would need to change the script manually, to add the MIRRORTO option and values. It was not included in the Schedule Backup wizard, to keep the GUI simple.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.