SQL Server Performance

mirroring and loshipping

Discussion in 'SQL Server 2008 Database Mirroring' started by lara99, Oct 5, 2009.

  1. lara99 New Member

    hi all i am planning to setup mirroring as well as logshipping on a single database.first question is this possible,if yes would sending transaciton to the mirroring will truncate the log on primary server resultingin lsn break for loshipping.( i mean will it break the logshipping)please throw some ideaslara,
  2. melvinlusk Member

    Although I've never tried this, I can't see mirroring breaking Log Shipping since your' logs are still being backed up and applied to the logshipped DB.
    Why are you using Log Shipping in this particular circumstance? If you're hoping to use Log Shipping as a reporting DB, why not just create a snapshot of the mirror to use for reports.....

Share This Page