Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Log Shipping Cannot Access the File Expand / Collapse
Author
Message
Posted Monday, January 19, 2009 10:18 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 2, 2014 3:01 PM
Points: 2, Visits: 200
Comments posted to this topic are about the item Log Shipping Cannot Access the File
Post #639651
Posted Tuesday, January 20, 2009 8:28 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 8:18 AM
Points: 318, Visits: 1,128
Great job and nicely done. We will be doing some log shipping soon and it's nice to know what to look out for.

Rudy



Post #639969
Posted Friday, May 8, 2009 7:21 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, January 8, 2014 3:23 PM
Points: 11, Visits: 72
Great article, i've stretched the copy and restore delays as far as i can within the sync limit though our log size surges seem fairly random so I can't schedule around them. This should resolve that issue.

Out of interest would it work if I simply ran the entire log shipping process within an SSIS package. Will the next task in the SSIS control flow not wait for the previous one to complete before executing thus avoiding the contention caused by the tasks stepping on each others toes?

Thanks

Chris
Post #712877
Posted Monday, June 22, 2009 8:37 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 2, 2014 3:01 PM
Points: 2, Visits: 200
I apologize for the delay in responding. No excuses, just the life of a DBA
The package I designed was for the destination server which means that it is assumed that the log backup and log shipping from the source server was already being managed through SQL Server, A third party backup software or through an SSIS package on the source server. The package I wrote takes files that were successfully copied and moves them to a new directory (on the same drive) for restoring. If you wanted to restore the logs within the same SSIS package, I would do the following:
Create a main SSIS Package to:
Execute the package (now a sub package) to move the log backup files (in this article) from the shipped logs directory to the Restore Directory.
Add a For Each Loop container that restores the transaction logs and then moves them into the Transaction log directory (for all completed restored logs).
Call this main package from a job. The job will not run unless the previous execution is completed.
If this is not what you were looking for please reply with new requirements.
Post #739438
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse