May 15, 2006 at 8:01 am
I would like to use two maintenance plans for backing up my database to two different locations. both plans would do full backups and transaction log backups.
Would this work, or would they interfer with each other?
I tried to do a google and could not find any information on this.
Thanks.
May 15, 2006 at 10:15 am
You could do this, but the problem is that when you take a backup you're backing up the log as well. To do a restore from logs you'd have to have both sets of backups and both sets of logs on hand. If you're using SQL Server 2005 Enterprise, you can look into using mirrored backup sets. If you're using SQL 2000, you probably want to backup to one location and then run a task which immediately copies that backup to another location.
May 16, 2006 at 10:48 am
You can do this, but a erstore will probably not work. dual full backups and transactino log backups will confure the recovery process immensely !!! However if you supply a bit more informaiton as to what you are trying to do, maybe some in the forunms can assist you.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply