If the job advert specifies a salary (or salary range) and you apply for the job, then that means you are prepared to work for the salary. Irrespective of what...

I have a great deal of sympathy for you Steve. A long, long time ago I wrote a training program for new recruits at my company, and had to design...

Using Micrsosoft Cluster Service to provide high-availability for MSSQL is a good technology, but it is not trivial to set up. Unfortunately, a lot of the complexity is hidden behind...

Yep, good point; inter-dependent databases are not something I would rely on Database Mirroring to handle nicely.

Sounds like you haven't had the best luck with MS Cluster. Absolutely agree that the network infrastructure is just as important. If nothing else, you'll get frequent unnecessary failovers with...

bbr (4/4/2008)

I don't agree. Database Mirroring is not...

Typically, in a production environment, logins, Agent jobs, etc do not change much (for the specific mirrored database in question). Other databases might be added, with their own logins, etc,...

For Logins, my advice is to stick with Windows Authentication only. That way, all logins are via domain users/groups - no logins need to be transferred.

Doesn't answer the main part...

Whilst it is true that a "biometric", such as the unique pattern of an iris, cannot easily be replaced, the electronic record of a biometric scan can be replaced/updated. I...

To me, it sounds like you are trying to achieve a Load Balancing solution, by using a High Availability solution. Remember, the sole purpose of a Microsoft Cluster is to...

Would be nice to know the outcome. The setup you have configured should work; I don't think there is a known, critical bug in the way Replication works in conjunction...

As a DBA, the unauthorised copying of any data under my control would be deeply embarrassing. But that wasn't your question!

My first thoughts were the same as Adam's....

Yep, that is my understanding too. Only the Principal and Mirror know about the Witness.

So, if your Distributor is only ever trying to contact the Principal, it sounds like...

Absolutely, ProcessMonitor from SysInternals (now part of the Microsoft, err, family) will help you figure out what permissions are required. The vast majority of problems are permissions to one or...

At my last work place, the Sys Admins implemented a new policy such that any workstation left unattended for 5 minutes would automatically lock, and then show the screensaver.

That REALLY...