You could potentially use Merge replication using Windows Sync Manager. Although I have never set this up personally. Reading through these articles it sounds plausible. I have assumed that any...

Basically your database on Server B is both a Subscriber and Publisher database? Is that what you mean? This should be fine albeit a bit funny to get your head...

ahh cool. At least it was something simple in the end. 🙂

yes, please do...and good luck!

I guess you got all bases covered 🙂

The only thing I can think of then (before an MS Support call!) is contention with all your Agent Jobs. Together with the...

OK so your server is Publisher, Distributor and Subscriber? Wow that is a LOT of Jobs on one server. Have you got deadlock tracing turned on? Maybe there is contention...

hmmm thats in interesting one. Are you using Push or Pull replication? What version of SQL Server is this? Are the Subscriptions going to different servers? Is the Distributor Remote...

mister.magoo (11/21/2014)

---

SQL_Baby (11/21/2014)

---

Ahh I see what you mean now. Maybe you can look into Server Logon Triggers which you can set to trigger on every connection to your server. There...

Ahh I see what you mean now. Maybe you can look into Server Logon Triggers which you can set to trigger on every connection to your server. There you might...

As part of my daily backup I usually script out all SQL jobs using PowerShell to an off-site location. As well as logins, server settings, linked servers, database and server...

um, restoring MSDB on a different server sounds a bit scary to me. Although I'm sure you could do it but probably wouldn't myself if I could help it.

I have...

see this link

http://iskrov.info/2013/11/how-to-disable-remote-access-microsoft-sql-server/

Hey,

Another suggestion you do as much filtering as you can of your data before you do you JOIN. So filter each table into Temporary variables and do the JOIN on...

if the Subscriber (with the missing data) is now active and receiving new inserted data ok, then you can manually insert the missing data from the Publisher database without breaking...

Hi, a solution that I have implemented and tested very successfully is as follows. Might not be exactly your scenario but it may give you some ideas.

My Scenario

One Production Server...