Post reply

Transaction Log shipping

  • September 2, 2005 at 2:10 am

    #363570

    Hi everyone ,

    Is transaction log shipping available in SQL 7 , as it is in SQL 2000 ?

    If not is there something similar that can be used without using replication ?

    many thanks for any help

  • September 2, 2005 at 5:55 am

    #587148

    You can implement the log shipping using sql-scripts

    Backup database 1, restore to other in Standby mode (with standby or normally)

    Backup log database 1, restore to other (with standby or no recovery)

    Backup log database 1, restore to other (with standby or no recovery) etc...

     

     

     

     

  • September 5, 2005 at 6:14 am

    #587561

    Hi,

    a good starting point is

    How to Perform SQL Server Log Shipping

    karl

    Best regards
    karl

  • September 5, 2005 at 6:22 am

    #587562

    Thanks everyone.

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

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