dbTalk Databases Forums  

SQL Logshipping 2005 - Load Delay Period Problem

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss SQL Logshipping 2005 - Load Delay Period Problem in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
pramodbura
 
Posts: n/a

Default SQL Logshipping 2005 - Load Delay Period Problem - 09-03-2007 , 01:29 AM






Hi,

We are implementing Log shipping feature of SQL Server 2005.
We are facing some issues when the RESTORE job is restoring the TRN
files on the Secondary server.

The error we are facing is as follows: "Skipping log backup file since
load delay period has not expired".

During the setup, we did specify the Delay Restoring Backups value to
0 (zero), but still it gives the above stated error message during
execution of RESTORE job.

The primary server has Enterprise Edition of SQL Server 2005 (SP2).
The secondary server has both, Enterprise Edition of SQL Server 2005
(SP2) and SQL Server 2000 (SP4) instance.

Please let us know if there is any link/solution for the above issue.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.