Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Log Shipping Cannot Access the File


Log Shipping Cannot Access the File

Author
Message
Bryan Bitzer-203060
Bryan Bitzer-203060
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 200
Comments posted to this topic are about the item Log Shipping Cannot Access the File
Rudy Panigas
Rudy Panigas
SSC-Addicted
SSC-Addicted (440 reputation)SSC-Addicted (440 reputation)SSC-Addicted (440 reputation)SSC-Addicted (440 reputation)SSC-Addicted (440 reputation)SSC-Addicted (440 reputation)SSC-Addicted (440 reputation)SSC-Addicted (440 reputation)

Group: General Forum Members
Points: 440 Visits: 1303
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



chris_hurley
chris_hurley
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
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
Bryan Bitzer-203060
Bryan Bitzer-203060
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search