SQL Server Performance

Log Shipping

Discussion in 'SQL Server Log Shipping' started by bugsydg, Sep 7, 2004.

  1. bugsydg New Member

    I have the following dilemma. i currently have log shipping running between 2 locations over a t1 which works ok. now i need to have the standby database accessable to a special application the needs to read and write to the database. i am currently stopping the log shipping on a nightly basis and copying the mdf and ldf and attaching them. is there any better way that would be more efficient and not require me to take down my database on the far side on a nightly basis?
  2. derrickleggett New Member

    You would need to use replication for this.

    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.
  3. satya Moderator

  4. sundeip New Member

    I had the same situation once, I used Merge Replication to fullfill my purpose . i would recommend the same for you also.

    Thanks
    Sandy

Share This Page