Backing Up Data on two different devices - HELP


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Backing Up Data on two different devices - HELP

  1. #1
    Jim Guest

    Backing Up Data on two different devices - HELP


    Here's what I'm trying to accomplish and would like some advice. SQL 7.0 &
    6.5 servers.

    I want to back up up my data both on the local disk (currently) and now to
    a remote backup server. These are mission critical servers and I currently
    do full backups at 6:00am and 6:00pm to the local and remote disk. The databases
    are not very big and take approximately 2-3 minutes to complete a full backup.
    From testing, I've found remote backups aren't much different. I run trans
    logs every 30 minutes between the fulls to ensure I don't miss anything.
    Very quick in both cases.

    My question is: If I'm am backing up at different times locally and remotely
    am I shooting myself in the foot as far as the trans action logs go? I pretty
    sure this has no effect on my full backups, but aren't the transaction logs
    truncated after they are backed up. If I backup the logs locally first then
    remotely, am I actually backing anything up or am I getting a log that will
    do me no good in a restore situation?

    If it helps, I could do full backups every hour to the remote box, skip the
    logs, but wouldn't that be excessive?

    I'm looking for any ideas on how I could do this correctly to ensure I have
    valid and restorable backups on both servers.

    Thanks,

    Jim



    jfarrell@hackley.hbocvan.com





  2. #2
    kevin knudson Guest

    Re: Backing Up Data on two different devices - HELP


    I can't help with 6.5, but you could setup a DTS job to backup the DB then
    copy the .bkp to the remote server. This would keep you backups in sync.
    I would also do the same with the logs, get them off the server asap.

    I don't know how you would time it, but you could do a background job using
    AT or WinAT to do the copy. With DTS you can coordinate the backup and then
    the copy.

    KlK, MCSE

    "Jim" <jfarrell@hackley.hbocvan.com> wrote:
    >
    >Here's what I'm trying to accomplish and would like some advice. SQL 7.0

    &
    >6.5 servers.
    >
    >I want to back up up my data both on the local disk (currently) and now

    to
    >a remote backup server. These are mission critical servers and I currently
    >do full backups at 6:00am and 6:00pm to the local and remote disk. The databases
    >are not very big and take approximately 2-3 minutes to complete a full backup.
    >From testing, I've found remote backups aren't much different. I run trans
    >logs every 30 minutes between the fulls to ensure I don't miss anything.
    >Very quick in both cases.
    >
    >My question is: If I'm am backing up at different times locally and remotely
    >am I shooting myself in the foot as far as the trans action logs go? I pretty
    >sure this has no effect on my full backups, but aren't the transaction logs
    >truncated after they are backed up. If I backup the logs locally first then
    >remotely, am I actually backing anything up or am I getting a log that will
    >do me no good in a restore situation?
    >
    >If it helps, I could do full backups every hour to the remote box, skip

    the
    >logs, but wouldn't that be excessive?
    >
    >I'm looking for any ideas on how I could do this correctly to ensure I have
    >valid and restorable backups on both servers.
    >
    >Thanks,
    >
    >Jim
    >
    >
    >
    >jfarrell@hackley.hbocvan.com
    >
    >
    >
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center