Bringing back to life...

Well, I think I have the budget ok'ed for the product.  In fact, I'll be purchasing the bundle (DBArtisan,ER/Studio and either change manager or Rapid SQL-you get...

Thank you all for the responses.  I'll keep working with it and then comes the biggest task of all, getting the ok to spend 3k on it

Thanks for the response.

To be honest, I haven't spent the time to review it much yet.  My main interest is to understand what it does that I cannot do already...

Allen,

You da man. Thanks for clearing my brain on this one. On one of the nodes I was using Windows Auth instead of SQL Server authentication to register...

I did register the off-site server in both EM using the same authentication mode.

Is that what you mean?

I have the email part in place with on failures...the part that is escaping me is how to get the last step run? Thanks for the reply wilson

Thank you. I also found the one on sqldts.com to work for me also. A little more involved with error checking with the first one I tried, which...

Thanks allen, but the directory is a share that I created.

The directory on the server is e:\program files\Microsoft SQL Server\MSSQL

I shared it as MSSQL so it is now \\machinename\mssql ...

Ok, I think I am close. I need to explain where I am at.

The server service and agent service are starting up with the same uid/pwd on...

The answer was, after you edit the names in disconnected edit, you have to open each connection object and click ok..this will update the name underneath the connection object.

That is great. Thanks for all your help. I will get this rolling and hopefully it will just click. Thanks again for all the help.

I see, thanks Allen. Much appreciated. So, my next question: How else can I achieve this. I cannot give access to production for mapping to shares...

Allen, thank you for bearing with me.

I think I am being confused by the share. The share on the production server or remote server? Do the servers both...

Thanks for the replies. Let me elaborate a bit.

The servers are on two different domains. When I go through the process, it appears I can browser the standby...

I am removing all data from the staging table each time. Everything in the staging table will be copied to the "golden" table, not just updating changes. I...