SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Backup and save a copy on a server on a different domain


Backup and save a copy on a server on a different domain

Author
Message
M.DBA
M.DBA
SSC Veteran
SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)

Group: General Forum Members
Points: 288 Visits: 336
Hi

I would like to set up a daily job that backs up the database and transfers a copy of the backup on to a disk on a different domain. I wonder how to pass the authentication when connecting to a different domain. Thank you in advance.:-)

M

Where there is a will... There is a way!
Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (138K reputation)SSC Guru (138K reputation)SSC Guru (138K reputation)SSC Guru (138K reputation)SSC Guru (138K reputation)SSC Guru (138K reputation)SSC Guru (138K reputation)SSC Guru (138K reputation)

Group: General Forum Members
Points: 138303 Visits: 18233
Junior DBA.M (4/17/2012)
Hi

I would like to set up a daily job that backs up the database and transfers a copy of the backup on to a disk on a different domain. I wonder how to pass the authentication when connecting to a different domain. Thank you in advance.:-)

M

You can either use pass through authentication which requires a matching local username and password on each server or if you have the appropriate trusts in place you may use domain accounts.
Can you provide a little more detail as to what your current situation provides

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
M.DBA
M.DBA
SSC Veteran
SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)

Group: General Forum Members
Points: 288 Visits: 336
Hi and thanks for your reply

We have two servers on a work group. The second server does not have SQL server on it, it is just a disk. It is Windows server 2003...

Where there is a will... There is a way!
Robin Sasson
Robin Sasson
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2027 Visits: 530
The second server has no SQL Server installed?

So is you question about attaching to database files located on a different domain?

Exclamation "Be brave. Take risks. Nothing can substitute experience." Exclamation
M.DBA
M.DBA
SSC Veteran
SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)

Group: General Forum Members
Points: 288 Visits: 336
Hi

The purpose of this job would be only to save a copy of the backup on the second server. There is no need to attach files or anything, its just to have a copy on a disk in the work group with a different domain, and I would like to know how to pass the authentication. Thanks.

Where there is a will... There is a way!
anthony.green
anthony.green
SSC Guru
SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)

Group: General Forum Members
Points: 63470 Visits: 8598
i would look at something like robocopy or xcopy running as batch file as a second step in the backup job which copies the files from server1 to server2



How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger


GSquared
GSquared
SSC Guru
SSC Guru (140K reputation)SSC Guru (140K reputation)SSC Guru (140K reputation)SSC Guru (140K reputation)SSC Guru (140K reputation)SSC Guru (140K reputation)SSC Guru (140K reputation)SSC Guru (140K reputation)

Group: General Forum Members
Points: 140567 Visits: 9731
Set up a shared directory on the second server, with "Full" permissions for an account on both domains. Then robocopy the files over.

If you can't do that, can you set up FTP on the second server and upload to that? Can be set for internal connections only. I've had to do that with remote servers that had strict domain account rules.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (138K reputation)SSC Guru (138K reputation)SSC Guru (138K reputation)SSC Guru (138K reputation)SSC Guru (138K reputation)SSC Guru (138K reputation)SSC Guru (138K reputation)SSC Guru (138K reputation)

Group: General Forum Members
Points: 138303 Visits: 18233
Junior DBA.M (4/17/2012)
Hi and thanks for your reply

We have two servers on a work group. The second server does not have SQL server on it, it is just a disk. It is Windows server 2003...

As both machines are in a workgroup you may use passthrough authentication, create a local user on each box with exactly the same password.

If you want the sql server instance to copy the files out to the remote server you will need to run the sql server service under this local user account, otherwise use a scheduled windows task to copy the files for you.

For more on pass through and moving files remotely in a workgroup or cross domains see my guide at this link. The guide mentions Log Shipping but the principals are the same.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
M.DBA
M.DBA
SSC Veteran
SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)

Group: General Forum Members
Points: 288 Visits: 336
Thank you. Will try and let you know if I was succesful .:-)

Where there is a will... There is a way!
M.DBA
M.DBA
SSC Veteran
SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)

Group: General Forum Members
Points: 288 Visits: 336
Hiiiii

thank you very much. I tested this and worked. w00t:-D:-)Hehe As you can see, I am an excited newbie!

Regards

Where there is a will... There is a way!
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