Sorry to be the bearer of bad news, but it sounds like there is a malfunction in the Prometric system and they are showing people as passing the MCM when...

It needs to be stored separated from the database backups. Not...

Disagree. Maintenance plans are better than nothing, but T-SQL backup scripts are much better. They are portable and easily reproducable. Plus maitnenance plans have had a lot of bugs over...

I would recommend storing the certificate backup in source control, not in a folder on the server.

It should always be done using Cluster Manager.

If you are using contained databases, then users in the database are kept in sync including their logins. Logins that do not map to a database user will not be...

Just to clarify 1 point: there is a log chain on the mirror database. It has the exact same log chain as the principal. Without it, you wouldn't be able...

To sum things up:

If you are running asynchronous (safety off) mirroring, the only way to fail over manually is to change the operating mode to synchronous (safety full), wait for...

Try dropping the existing database and restore without using the REPLACE option.

I suspect that the reason the ID values cannot be rolled back is because in order to roll them back, it would have to reseed the identity value and other...

Running out of space on the drive is a symptom, not the cause. You need to look past the symptom to see what caused it. Possible root causes would be...

No, wasn't a real question. Was just playing along. 🙂

Ooh ooh. So what does ROM mean? 😀

Thanks for the explanation, Gail! That makes a lot of sense.

If you modify the schema...