March 10, 2008 at 8:31 pm
I'm trying to backup a database from domain-A on to other windows server sitting on domain-B.
I know we can map the drive but that will ask for login credentials.
I would to do it thru script or sql job - Is there any way to do this? Please suggest.
Thanks for the help!
March 10, 2008 at 9:01 pm
Is there Trust setup between the domains? If so grant your SQL Server Agent account write rights on the share on the other server.
BTW-it is not a best practice to backup across the network. There are issues that will come up, particularly as you get into larger DB's. Backup locally and then move the file to a network location.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 11, 2008 at 8:10 am
As stated before, SQL Server does not back up over the network very well and is not recommended. The best way to do so is to backup locally and then copy/move the file over the network.
This is done because with the amount of processes monitored by SQL Server, any small blip on the network will cause your backup to fail even if the network connection is lost for a split second.
Look under the script section to obtain a script on how this can be done.
Hope this helps.
Marvin Dillard
Senior Consultant
Claraview Inc
March 18, 2008 at 4:22 am
Dear Swetha,
You want take the backup of a database on domain-a to domain-b. But this is not recommended because if there is a slight network interruption the backup fail and this can cause loss to your valuable data and as well as your job. Other alternatives before you are replication,log shipping or database mirroring.
Regards
Chandra Mohan N
[font="Verdana"]Thanks
Chandra Mohan[/font]
March 18, 2008 at 1:12 pm
You should take the backup on same server and then move backup to another server using xcopy or robocopy. DBA job is to reduce the risk and worst if he doesn't have a good backup then total mess up.
SQL DBA.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply