Re: Read your article on Log Shipping....

0 views

Skip to first unread message

barathan esakiappan

unread,

Jul 21, 2008, 3:24:38 AM7/21/08

to Larry Dinsmore, sqlth...@googlegroups.com

Dear Larry Dinsmore

Thank you so much for reading my blog SQLThoughts.

This message you got from restore job history may be due to

i) -there is no recent full backup of the database so that the log backups can be performed. Take a full backup of the database for which you configured the LOG Shipping.

ii) Check the privilages for the SQL Server Agent Service user for the folder configured for storing the .trn file ( transaction log backup file ) . This may be a network shared folder for the both cases in which SQL Server in a domain or SQL Server in a non-domain scenarios.

I think any one of the above may solve your problem. Please let me know the feed back!

With Regards

B.Esakkiappan

SQLThoughts

Discussions @ http://groups.google.com/group/sqlthoughts

----- Original Message ----
From: Larry Dinsmore <ldin...@klc.org>
To: b_e...@yahoo.com
Sent: Thursday, 17 July, 2008 6:49:01 PM
Subject: Read your article on Log Shipping....

I really got a lot out of it, thanks. I have log shipping set up and am confused by this message in the restore job history “Skipped log backup file. Secondary DB:….” . Does that mean there was nothing to restore?

Larry Dinsmore

__________________________________________________
This electronic mail transmission is intended solely for the named
individual or entity to which it is addressed and may contain
information that is confidential, proprietary and/or legally
privileged. If you are not the intended recipient, do not read,
copy, retain, forward or otherwise disseminate this message or any
attachment. If you have received this transmission in error, please
notify the Kentucky League of Cities via reply e-mail or at
(859) 977-3700 and delete all copies of the message and any
attachment from your system.
___________________________________________________