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


Log Shipping scans files but doesn't restore


Log Shipping scans files but doesn't restore

Author
Message
abedenbaugh
abedenbaugh
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: 34
SQL_Bob (1/14/2014)
Alright, after much more experimentation, it turns out that what I'm trying to do *can* work, provided that the formatting of the log backup file names exactly matches what log shipping is expecting.

I'll be working on a blog post detailing everything discussed here as well as how I solved each step. Will include a link when it's up. Thank you everyone for your help!


Bob did you ever get a chance to write this info up? I am in the exact same situation you are in regarding the logs coming in from an external company and sure could use some help.
tatransue
tatransue
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 8
I would love to hear how you set up Log Shipping databases with FTP or dropbox. We have several Goodwill stores running SQL 2008 R2 Workgroup and do not have a VPN or any connection to our main office and I am trying to set up a data mart so I would like to have "copies" of the various stores databases so I can manipulate their data to have reports on the stores combined and individual. We do not want to connect the databases to make sure we do not violate PCI Compliance. Obviously we also have budgetary issues with trying to keep our money to the mission and not operations. Any suggestions would be appreciated.

Tracy
dan-572483
dan-572483
SSChasing Mays
SSChasing Mays (643 reputation)SSChasing Mays (643 reputation)SSChasing Mays (643 reputation)SSChasing Mays (643 reputation)SSChasing Mays (643 reputation)SSChasing Mays (643 reputation)SSChasing Mays (643 reputation)SSChasing Mays (643 reputation)

Group: General Forum Members
Points: 643 Visits: 1958
I'm having the same issue which I described in the thread "Log shipping restore job doesn't restore"

Interestingly, this is also not standard SQL Log Shipping. The log files originate on an Internet-facing domain and are passed through a firewall via an FTP job to a server in a secure domain.

Oddly there are five databases on the Internet-facing instance that send their log files through the firewall to the same target instance, and four of the restore jobs work - one doesn't.

If anyone has figured this out please let us know.
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