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

I've got someone setting up a "backup-relay" server on our intranet. It will transfer our local backups off-site, and transfer backups of our production db (which is off-site) back home. These are all Windows systems (Server 2008 R2, SQL Server 2008, TMG).

They're having problems getting traffic through, and I was asked if it would be ok to put the production db in our local/home/internal domain?

I'm a developer/dba/*nix guy, with only a little sysadmin experience on Windows, so I thought I'd ask if this setup is copacetic?

share|improve this question
    
There should not be any standard/generic reasons to not make the move, but there is probably more details that you haven't provided yet. Why is your production DB offsite? –  Tim Jan 17 '12 at 13:42
    
The prod db is offsite because we have BFE-adjacent offices and used to have tiny internet tubes ;-) –  thebjorn Jan 18 '12 at 14:04

1 Answer 1

up vote 2 down vote accepted

I personally would bang on them a little more to make the traffic work before reconfiguring your environment in such a way. Not that it's necessarily a bad config to move to, but you're still going to go through the pains of getting the traffic flowing if you move your db in house.

What are the problems that they're having with traffic? Chalk it up to pessimism if you want, but it sounds to me like this is someone who is either over their head not going the distance to get the problem solved.

share|improve this answer
    
They've abandoned the approach, so I'm guessing you were right to be pessimistic. –  thebjorn Jan 18 '12 at 14:07

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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