 | |
LOG Shipping on different Domain Computers.
microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
LOG Shipping on different Domain Computers. -
05-06-2008
, 09:47 AM
#2
| |||
| |||
|
|
I have a scenario where I have 2 environments. a) Production [ 2node (active-active) sql 2k Cluster] b) Test [2 Node (active-active) sql2k Cluster] We maintain a current copy of our DB for Dev purpose. Currently I'm synching the 2 db's using a DTS job. (just synching the tables that I work on) I intend to sync up the entire db and I guess Log shipping would be the most efficient way to do it. I am running into a problem when I try to select the destination server on the <Specify the Log Shipping Destination> dialog box of Log Shipping. Since the two env are on separate domains I don't think I can have a common windows account that can grant access to all the servers. Is there a way to circumvent this issue. Thank you all Regards Beachcomber |
#3
| |||
| |||
|
|
I have a scenario where I have 2 environments. a) Production [ 2node (active-active) sql 2k Cluster] b) Test [2 Node (active-active) sql2k Cluster] We maintain a current copy of our DB for Dev purpose. Currently I'm synching the 2 db's using a DTS job. (just synching the tables that I work on) I intend to sync up the entire db and I guess Log shipping would be the most efficient way to do it. I am running into a problem when I try to select the destination server on the <Specify the Log Shipping Destination> dialog box of Log Shipping. Since the two env are on separate domains I don't think I can have a common windows account that can grant access to all the servers. Is there a way to circumvent this issue. Thank you all Regards Beachcomber |
#4
| |||
| |||
|
|
I have a scenario where I have 2 environments. a) Production [ 2node (active-active) sql 2k Cluster] b) Test [2 Node (active-active) sql2k Cluster] We maintain a current copy of our DB for Dev purpose. Currently I'm synching the 2 db's using a DTS job. (just synching the tables that I work on) I intend to sync up the entire db and I guess Log shipping would be the most efficient way to do it. I am running into a problem when I try to select the destination server on the <Specify the Log Shipping Destination> dialog box of Log Shipping. Since the two env are on separate domains I don't think I can have a common windows account that can grant access to all the servers. Is there a way to circumvent this issue. Thank you all Regards Beachcomber |
#5
| |||
| |||
|
|
I have a scenario where I have 2 environments. a) Production [ 2node (active-active) sql 2k Cluster] b) Test [2 Node (active-active) sql2k Cluster] We maintain a current copy of our DB for Dev purpose. Currently I'm synching the 2 db's using a DTS job. (just synching the tables that I work on) I intend to sync up the entire db and I guess Log shipping would be the most efficient way to do it. I am running into a problem when I try to select the destination server on the <Specify the Log Shipping Destination> dialog box of Log Shipping. Since the two env are on separate domains I don't think I can have a common windows account that can grant access to all the servers. Is there a way to circumvent this issue. Thank you all Regards Beachcomber |
#6
| |||
| |||
|
|
I have a scenario where I have 2 environments. a) Production [ 2node (active-active) sql 2k Cluster] b) Test [2 Node (active-active) sql2k Cluster] We maintain a current copy of our DB for Dev purpose. Currently I'm synching the 2 db's using a DTS job. (just synching the tables that I work on) I intend to sync up the entire db and I guess Log shipping would be the most efficient way to do it. I am running into a problem when I try to select the destination server on the <Specify the Log Shipping Destination> dialog box of Log Shipping. Since the two env are on separate domains I don't think I can have a common windows account that can grant access to all the servers. Is there a way to circumvent this issue. Thank you all Regards Beachcomber |
#7
| |||
| |||
|
|
I have a scenario where I have 2 environments. a) Production [ 2node (active-active) sql 2k Cluster] b) Test [2 Node (active-active) sql2k Cluster] We maintain a current copy of our DB for Dev purpose. Currently I'm synching the 2 db's using a DTS job. (just synching the tables that I work on) I intend to sync up the entire db and I guess Log shipping would be the most efficient way to do it. I am running into a problem when I try to select the destination server on the <Specify the Log Shipping Destination> dialog box of Log Shipping. Since the two env are on separate domains I don't think I can have a common windows account that can grant access to all the servers. Is there a way to circumvent this issue. Thank you all Regards Beachcomber |
#8
| |||
| |||
|
|
I have a scenario where I have 2 environments. a) Production [ 2node (active-active) sql 2k Cluster] b) Test [2 Node (active-active) sql2k Cluster] We maintain a current copy of our DB for Dev purpose. Currently I'm synching the 2 db's using a DTS job. (just synching the tables that I work on) I intend to sync up the entire db and I guess Log shipping would be the most efficient way to do it. I am running into a problem when I try to select the destination server on the <Specify the Log Shipping Destination> dialog box of Log Shipping. Since the two env are on separate domains I don't think I can have a common windows account that can grant access to all the servers. Is there a way to circumvent this issue. Thank you all Regards Beachcomber |
#9
| |||
| |||
|
|
I have a scenario where I have 2 environments. a) Production [ 2node (active-active) sql 2k Cluster] b) Test [2 Node (active-active) sql2k Cluster] We maintain a current copy of our DB for Dev purpose. Currently I'm synching the 2 db's using a DTS job. (just synching the tables that I work on) I intend to sync up the entire db and I guess Log shipping would be the most efficient way to do it. I am running into a problem when I try to select the destination server on the <Specify the Log Shipping Destination> dialog box of Log Shipping. Since the two env are on separate domains I don't think I can have a common windows account that can grant access to all the servers. Is there a way to circumvent this issue. Thank you all Regards Beachcomber |
#10
| |||
| |||
|
|
I have a scenario where I have 2 environments. a) Production [ 2node (active-active) sql 2k Cluster] b) Test [2 Node (active-active) sql2k Cluster] We maintain a current copy of our DB for Dev purpose. Currently I'm synching the 2 db's using a DTS job. (just synching the tables that I work on) I intend to sync up the entire db and I guess Log shipping would be the most efficient way to do it. I am running into a problem when I try to select the destination server on the <Specify the Log Shipping Destination> dialog box of Log Shipping. Since the two env are on separate domains I don't think I can have a common windows account that can grant access to all the servers. Is there a way to circumvent this issue. Thank you all Regards Beachcomber |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.