March 1, 2010 at 7:42 am
We've been trying to use logshipping to transfer our data to an offsite location. However, about once per week, the LSN's are out of sync and we've traced it to missing .trn files.
There are no other programs performing regular backups or transaction log backups from the primary.
Here are my setting:
Backups - 5 min
Delete Backups older than - 1 day
Copy - 5 min
Delete Copied Files After - 2 days
Restore - 5 min
I'm starting to think that the Delete Copied Files After selection pretty much deletes everything in the directory every 2 days whether or not one of the files was restored.
So a file that was recently copied, gets deleted if the delete operation occurs. At that point the restore fails because the .trn file is missing/deleted.
I think that the delete copied files option has nothing to do with the age of the actual file just the contents of the directory during the delete process.
Any thoughts on this?
March 1, 2010 at 7:58 am
You can try using the default trace to check if someone issued a backup log statement.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 1, 2010 at 10:32 am
Adi Cohn-120898 (3/1/2010)
You can try using the default trace to check if someone issued a backup log statement.Adi
I ran profiler for just the audit backup/restore events. From 10:45 - 12:30, the only backups that occured are the transaction log backups for this log shipping procedure.
James
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply