<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server Newbies
»
Backup and save a copy on a server on a...
15 posts, Page 1 of 2
1
2
»»
Backup and save a copy on a server on a different domain
Rate Topic
Display Mode
Topic Options
Author
Message
M.Nobakht
M.Nobakht
Posted Tuesday, April 17, 2012 4:22 AM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, May 09, 2013 9:35 AM
Points: 8,
Visits: 193
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
Post #1284796
Perry Whittle
Perry Whittle
Posted Tuesday, April 17, 2012 4:33 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 6:53 AM
Points: 5,204,
Visits: 11,164
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"
Post #1284812
M.Nobakht
M.Nobakht
Posted Tuesday, April 17, 2012 6:03 AM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, May 09, 2013 9:35 AM
Points: 8,
Visits: 193
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...
Post #1284846
Robin Sasson
Robin Sasson
Posted Tuesday, April 17, 2012 6:22 AM
Say Hey Kid
Group: General Forum Members
Last Login: Monday, February 18, 2013 6:17 AM
Points: 674,
Visits: 472
The second server has no SQL Server installed?
So is you question about attaching to database files located on a different domain?
"Be brave. Take risks. Nothing can substitute experience."
Post #1284857
M.Nobakht
M.Nobakht
Posted Tuesday, April 17, 2012 6:29 AM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, May 09, 2013 9:35 AM
Points: 8,
Visits: 193
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.
Post #1284858
anthony.green
anthony.green
Posted Tuesday, April 17, 2012 6:30 AM
SSCertifiable
Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075,
Visits: 4,831
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
Want an answer fast? Try here
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
CrossTabs-Part1
&
Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger
Post #1284860
GSquared
GSquared
Posted Tuesday, April 17, 2012 6:36 AM
SSCoach
Group: General Forum Members
Last Login: Tuesday, May 21, 2013 1:55 PM
Points: 15,442,
Visits: 9,571
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
Post #1284863
Perry Whittle
Perry Whittle
Posted Tuesday, April 17, 2012 7:02 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 6:53 AM
Points: 5,204,
Visits: 11,164
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"
Post #1284894
M.Nobakht
M.Nobakht
Posted Tuesday, April 17, 2012 8:22 AM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, May 09, 2013 9:35 AM
Points: 8,
Visits: 193
Thank you. Will try and let you know if I was succesful .
Post #1284955
M.Nobakht
M.Nobakht
Posted Wednesday, May 02, 2012 8:31 AM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, May 09, 2013 9:35 AM
Points: 8,
Visits: 193
Hiiiii
thank you very much. I tested this and worked.
As you can see, I am an excited newbie!
Regards
Post #1293884
« Prev Topic
|
Next Topic »
15 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
