471,122 Members | 876 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,122 software developers and data experts.

Log Shipping Issues

I'm having issues setting up log shipping on a remote server. We have a very large production database that needs to be migrated offsite. The db is 9 GB backed up. It takes about 4 hours to copy the file to the remote server when it is archived. During the log shipping process the file takes a lot more time than that to arrive at the remote server. I decided to use log shipping for this migration, because we can't have our production box down for the 4 to 8 hours it would take to migrate the database, migrate replication, etc.

After several attempts using the Wizard in SQL 2000, my latest hump is an inability to restore the log files.

Server: Msg 4305, Level 16, State 1, Line 1
The log in this backup set begins at LSN 114798000000031800001, which is too late to apply to the database. An earlier log backup that includes LSN 114762000000056700001 can be restored.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE LOG is terminating abnormally.

The db file that initialized on the remote server was last modified 3/28/2007 10:56 AM and the first log file available for restore on the remote server is 3/29/2007 4:11 AM.

Is there a workaround for this? I'm trying a newer full backup of the db and looking at doing a point in time restore. Thoughts, suggestions?
Mar 29 '07 #1
0 1232

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Jason Huang | last post: by
reply views Thread by InProcess | last post: by
1 post views Thread by tram | last post: by
10 posts views Thread by Howard Martin | last post: by
reply views Thread by ppatel | last post: by
reply views Thread by Parveen.Beniwal.Daffodil | last post: by
6 posts views Thread by Chris Buckett | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.