Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

My real question here is... is there a tool I can use?

(E.g. I have a lot to do, and would prefer not to script it all up myself!)

Anyone using the redgate (hmmm, they had a tool for this, but I do not see it on their web site now...)

I have a primary web app at rackspace. Am setting up a backup copy of the app in another data center. I want to use SQL log replication to sync the db.

Using SQL Server Web Edition.

TIA for suggestions and insight!

share|improve this question

closed as too localized by Ward, freiheit, Scott Pack, RobM, mailq Jan 17 '12 at 22:04

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

    
If you have a VPN or some other connection, you can set up a UNC path pretty easily. Just edit windows/system32/drivers/etc/hosts and put an entry for it in there. Then you can do \\foobar –  Matt Rogish Nov 6 '09 at 17:02

5 Answers 5

Even if Web edition did support Log Shipping (see icelava's answer), you can log ship without a mapped drive. We do it all the time. You just ship to a UNC share (\\server\share).

You can set it all up using the Log Shipping wizard in the SQL Server Management Console, no need to script it if you don't want (or, it will generate the script for you I believe and you can just modify it appropriately for each instance you want to run it on).

Looking at more detail in your question, sounds like what you mean is "How do I log-ship without using a share" (i.e. your 2nd web server is not on the same network). AFAIK, you can't, but what you can do fairly easilly is set up a VPN between the two. If you own both the servers (or they are VPS's), then setting up a VPN is as easy as installing a program called Hamachi at both ends and then you can communicate between the two using the IP address as your sharename (e.g. \\5.x.x.x\share).

Edit: I see that your question now reflects the UNC path part of the answer

share|improve this answer
    
You answered the wrong question.... we specifically do not want/have UNC access... –  samsmith Dec 14 '11 at 16:24
    
And yet you wrote on another answer...I believe the native utility still requires a mapped drive, which I need to avoid - also I'm not quite sure how you can have a mapped drive without UNC access... –  Mark Henderson Dec 14 '11 at 19:30

what connectivity do you have between the datacenters? The end result should be that you have a copy of of log backup that's being taken at your primary, copied somehow to your secondary.

The easiest way to do this in a windows environment is to share out a UNC path and do an xcopy. But, of course if you cannot do that, you may be able to figure out more creative ways. Here are some other ways besides using CFS/SMB to move the transaction log backup:

  • ftp
  • tftp
  • sftp
  • scp
  • rsync
  • http on the primary & wget/curl on the secondary

In all of these cases you will need to setup an additional service on the primary db server, and a client on the secondary db server & script the copy of the files, as well as poke the right holes through your filewall.

share|improve this answer

Well, this did not get the answer I was really looking for...

I was hoping to get a reference to either:

  • some ready to use scripts
  • a free or commercial tool

That could use http, ftp, or other protocol to move the logs around.

The answer seems to be:

  • Roll your own log shipping, don't use the SQL Server built in stuff
  • Use powershell scripts on AT to move the data and run the log creation and integration steps
  • In powershell, code whatever data encryption and data movement mechanism that works for you

I would STILL like to find a real tool... but for now, this seems to be the best that can be done...

share|improve this answer
up vote 0 down vote accepted

The most straightforward out of the box approach is to use Red Gate SQL Backup, which has full log shipping support, and support for various log file transfer methods built in.

When I asked this question, I was hoping to learn of other commercial/foss solutions short of coding it all up myself.

share|improve this answer

Log Shipping is a feature in Standard, Enterprise, or Workgroup editions. Web edition does not support it.

share|improve this answer
    
True, the native log shipping utility is not part of Web, but you can still do it with scripts... and I believe the native utility still requires a mapped drive, which I need to avoid.... –  samsmith Jul 21 '09 at 4:18

Not the answer you're looking for? Browse other questions tagged or ask your own question.