Post reply

Last file loaded is first_file_000000000000.trn

  • February 24, 2005 at 1:12 am

    #85541

    Hi,

    In log shipping,I check the Log Shipping Pair Properties, the "Last backup file" and "Last file copied" are fine, but the "Last file loaded" is first_file_000000000000.trn, seems something wrong with the log shipping configuration.

    The destination database is set read only in the mean time.  All MSSQL and SQLServerAgent service use the same domain account to start.  But Primary Server and Secondary Server are on two different domains running Windows 2003 and NT4 sp4 respectively.  They are set to two way trusted.

    Would someone kindly give me some hints?  Thanks!

    Jason

     

  • February 28, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • February 28, 2005 at 4:21 pm

    #544518

    Try updating msdb..logshipping_secondaries table on the log shipping monitoring server to the actual  last loaded file name and timestamp.  It might pick up after that.

    Did you specify "Windows authentication" when setting up log shipping?  There might me an security issue with cross -domain accounts.  If this is the case, you can try changing the security mode by running the sp_define_log_shipping_monitor stored procedure.

     

  • February 28, 2005 at 10:14 pm

    #544530

    Thanks!  After I removed the destination database and copied by the log shipping process - add destination database, then the Log Shipping configuration is completed!  I was able to testing the restore database procedure from then.

    Thanks for you guys coming to the rescue!

    Jason

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

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