SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Log Shipping Problem
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Fonkberry
Starting Member

5 Posts

Posted - 03/05/2004 :  10:01:53  Show Profile  Reply with Quote
Hello,

I am in Log Shipping hell. I thought log shipping was supposed to be so strait forward and easy!

After setting up log shipping I have four databases that continue to try an load the first_file_000000000000.trn log, that is created when the plan is first initialized. It happens even though the backup/copy/loads are functioning successfully and according to the plan schedule, and this initial file doesn't even exist in the designated share because it's been deleted according to the log retention schedule. This is some crazy:crazy: Microsoft crap! When are these people going to produce a utility that actually works? What else should I have expected.....Anyway, here is the error: It's like...tell me something I don't know, like why is this happening!

[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 4305: [Microsoft][ODBC SQL Server Driver][SQL Server]The log in this backup set begins at LSN 33000000022600001, which is too late to apply to the database. An earlier log backup that includes LSN 33000000011800001 can be restored.
[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE LOG is terminating abnormally.


Any help anyone can give would be greatly appreciated. Thank you much!

Ren Flot

MuadDBA
Aged Yak Warrior

USA
628 Posts

Posted - 03/05/2004 :  15:17:03  Show Profile  Reply with Quote
Please don't cross post. See topic in General SQL Server for my response.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000