Post reply

SQL Server 2005 Log Shipping Backup Share Selection

  • January 23, 2007 at 4:01 pm

    #171179

    I'm implementing log shipping for the purpose of maintaining a warm database for failover.  The log shipping documentation on where is the best place to place the transaction log backups is vague.  I'm going to store the files in a separate share (not in the primary or secondary server but on a dedicater filer).  Can you comment as to whether this is a good practice?

     

    Thanks,

    Carlos.

    Regards,

    Carlos

  • January 23, 2007 at 11:09 pm

    #685141

    It is good idea to keep your backups safe...

    Backup/Restore might be slow becuase you have use backup files from 3rd server...but speed is depends on your network...and server NIC configuration...

    MohammedU
    Microsoft SQL Server MVP

Viewing 2 posts - 1 through 1 (of 1 total)

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