Yeah, I'm coming to that same conclusion myself, that peer to peer transaction replication is likely to be the solution here I think. Now I've just got to think about...

Thanks for the responses. And yes, just to clarify, my requirement would be to have both clusters available for read/write operations simultaneously, with the write operations synchronised between the two...

Gift Peddie (4/28/2011)

---

SQL Server 2008 comes with SSIS Connection project...

homebrew01 (3/30/2010)

---

When testing. I get an error that I cannot access the production database, even though the case statement should only be accessing development. I guess it checks permissions even...

I had to do something similar a while back as part of an audit review, and I ended up writing a VB.Net application to monitor disk space usage (as opposed...

Uncle Moki (3/30/2010)

---

If the job owner has sysadmin authority, the job always runs under the SQL Agent security context.

...

If the job step Run As is blank, the step runs under...

K. Brian Kelley (3/17/2010)

---

As mentioned previously, schema tend to be the way to go, although we usually grant VIEW DEFINITION at the database level for our developers to be able...

Uncle Moki (3/29/2010)

---

I don't think so...at least that's not what I'm seeing....

No, SQL jobs run under the context of whoever owns that job,...

In the restore routine the first thing I just do is query the remote (ie server that's performing the backup) MSDB database to retreive what the filename was and just...

F. van Ruyven (3/12/2010)

---

The following works for me:

* Create a new database 'MyDB_SourceBackup'

* Copy all definitions (tables, sp's etc.) from MyDB to MyDB_SourceBackup (using SQLCompare)

* Restore a full backup from...

I use a scheduled VB.Net application to poll various servers to make sure that services are running, websites are up, and ping requests are being replied to etc, then I...

The NT Authority\Anonymous Logon is the clue here I think, as I've had this before.

I believe you're using SSMS locally on PC A, to connect to Server A, and then...