Post reply

how to backup a sql server database from one domain to another

  • October 27, 2006 at 9:07 am

    #113987

    I need to backup a database from Domain A to Domain B, my problem right now is they are not talking each other

    how I can do that?

    any ideas?

    thanks in advance

  • October 27, 2006 at 9:40 am

    #668542

    Unless you are a domain administrator in both domains, you can't do what you want.  The Domain Admin. must set up a trust relationship between both domains.  Are theses scheduled backups using SQL Agent?  If so, SQL Agent will need to run under a Domain account in Domain A and that account must be given access to the destination folder in Domain B.  This is just a short-list of what needs done.  Contact your Domain administrator for help. 

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • October 27, 2006 at 5:19 pm

    #668609

    As John said, there are too many variables to go into here...in addition to what he suggests, you have to find out if there is a firewall between the two domains - and does allow the connection?

    Backing up across domains is not a good practice. What happens if the connection is lost? Can you afford to not have a backup?

    -SQLBill

  • October 27, 2006 at 7:55 pm

    #668620

    if both servers are mixed-mode, what about using a local SQL account for authentication and passing it in the script?

    one interesting bug I've found with MS is if you have the same name and password account on both ends it works a lot of times. if not passing it in a script, make local sql accounts on both ends named the same and the same password, then run the job under that account

  • November 1, 2006 at 2:04 pm

    #669335

    This is what I do.  I backup DatabaseA on ServerA, Remote logon to ServerA, zip it, copy it to ServerB on the other domain

    (copy D:\pgmFiles\MSSQL\Backup\DBA.BAK  \\RemoteServerB\d$\pgmfiles\MSSQL\BACKUP\ ),

    unzip it, restore on ServerB.

    What do you mean by ... "my problem right now is they are not talking each other"  You've got to have some kind of connection between them, otherwise you dump it to a CD and walk (drive, FedEx) it over to the other machine.

  • November 1, 2006 at 2:46 pm

    #669350

    Using mapping drives?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply