Post reply

Keeping Current

  • November 28, 2012 at 3:40 pm

    #270854

    Hi All...

    I have a set of databases located at a facility hours away. I have a machine here at the office. The databases at the remote facility are already mirrored to a second server for redundancy. As part of our backup plan, we do transaction log backups every hour during the work day.

    I would like to copy the logs to my location server and restore them so that the data on my local server is current _AND_ accessible for backups, etc. Does anyone know of any scripts or have ideas how I can automate this with a script that is dynamic?

    Any ideas appreciated.

    Thanks,

    Mike

  • November 28, 2012 at 4:05 pm

    #1563498

    mike 57299 (11/28/2012)

    Hi All...

    ... As part of our backup plan, we do transaction log backups every hour during the work day.

    I would like to copy the logs to my location server and restore them so that the data on my local server ...

    ... Does anyone know of any scripts or have ideas how I can automate this with a script that is dynamic?

    Have you considered log shipping over FTP?

    Edit: truncated the quote...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

  • November 28, 2012 at 4:13 pm

    #1563502

    Can that be done in addition to mirroring?

  • November 29, 2012 at 5:26 am

    #1563689

    mike 57299 (11/28/2012)

    Can that be done in addition to mirroring?

    http://msdn.microsoft.com/en-us/library/ms187016.aspx

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply