September 20, 2010 at 12:29 pm
Hello Everyone
Is there a way to NOT have the older log files deleted? I would rather delete the files thru a SQL job.
Some days the Log Shipping will get out of sequence because the process that deletes the old files, will delete the wrong files, one that has not been restored yet. And that will throw the process out of sync.
Thanks
Andrew SQLDBA
September 20, 2010 at 12:38 pm
Isn't there a cleanup job on the secondary? sorry, don't have a LS test system here setup. Could you disable that?
September 20, 2010 at 12:48 pm
AndrewSQLDBA (9/20/2010)
Hello EveryoneIs there a way to NOT have the older log files deleted? I would rather delete the files thru a SQL job.
Some days the Log Shipping will get out of sequence because the process that deletes the old files, will delete the wrong files, one that has not been restored yet. And that will throw the process out of sync.
Thanks
Andrew SQLDBA
it is the restore job that controls the delete process, so don't see how that is happening.
---------------------------------------------------------------------
September 20, 2010 at 12:53 pm
Hey George
I have had to code the restore process by hand. It is sitting behind a DMZ. I did leave the backup process in the Log Shipping statement.
The primary database has an entry in one of the tables that tells how long to keep the log files. I have set it to 0, and that does not work. I have also set the number really high, that does not work either.
Andrew SQLDBA
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply