Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Backup and save a copy on a server on a different domain Expand / Collapse
Author
Message
Posted Tuesday, April 17, 2012 4:22 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, June 30, 2014 7:33 AM
Points: 16, Visits: 282
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!
Post #1284796
Posted Tuesday, April 17, 2012 4:33 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:00 AM
Points: 6,300, Visits: 13,584
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
Posted Tuesday, April 17, 2012 6:03 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, June 30, 2014 7:33 AM
Points: 16, Visits: 282
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!
Post #1284846
Posted Tuesday, April 17, 2012 6:22 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, June 27, 2014 7:41 AM
Points: 739, Visits: 518
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
Posted Tuesday, April 17, 2012 6:29 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, June 30, 2014 7:33 AM
Points: 16, Visits: 282
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!
Post #1284858
Posted Tuesday, April 17, 2012 6:30 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:53 AM
Points: 5,218, Visits: 5,072
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
Posted Tuesday, April 17, 2012 6:36 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
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
Posted Tuesday, April 17, 2012 7:02 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:00 AM
Points: 6,300, Visits: 13,584
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
Posted Tuesday, April 17, 2012 8:22 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, June 30, 2014 7:33 AM
Points: 16, Visits: 282
Thank you. Will try and let you know if I was succesful .

Where there is a will... There is a way!
Post #1284955
Posted Wednesday, May 2, 2012 8:31 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, June 30, 2014 7:33 AM
Points: 16, Visits: 282
Hiiiii

thank you very much. I tested this and worked. As you can see, I am an excited newbie!

Regards


Where there is a will... There is a way!
Post #1293884
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse