Post reply

Log-shipping and importing data/objects

  • November 16, 2006 at 11:41 am

    #69151

    Good afternoon.  Does anyone have any information on why log-shipping breaks on one database when one of my db users imports objects and/or data from another database?  I know that it has something to do with it causing the transaction log to over-run/back-up, but I can't find documentation anywhere.  Also, does anyone know how to stop this process?  We're running SQL 2K SP4 on Windows 2003 SP2.  Any help is greatly appreciated.  Thanks.

    Chris

  • November 16, 2006 at 12:57 pm

    #672428

    Here is my guess. You have more than one chanel to dump data to your database. In log shipping, your database is waiting for logs with right lsn. If you could import data in between two log shippings, the lsn will be changed. SQL Server will find the next log shipping has a wrong lsn. That is the reason why the log shipping would fail.

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

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