It looks pretty good. There are a few other areas that you may want to investigate:

1) The bad data could still be in server memory - reboot the server?

2)...

http://msdn.microsoft.com/en-us/library/ms178578.aspx

So what exactly are you trying to protect against? Is securing the application, SQL Server, drives, backups, network traffic (and don't forget the information could also reside in server...

I believe that I've seen this before; are you using the wizard to create a script? In my case the script was incorrect and I had to step through...

1) Point it to the principal. If you want the benefits of automatic failover in the app then use the native client and set the connection string failover partner...

I think you may be referring to replication snapshots or a database backup/restore solution. I would take one of these approaches:

a) try and run a query on the principal...

Think this is what you are looking for :

http://www.microsoft.com/learning/en/us/certification/cert-overview.aspx#tab5

It will if it has been loaded in previously and not unloaded, otherwise...

I'm a little confused by your post - are you talking about database snapshots rather than snapshot replication or some other copy? If so, how can you run off...

It might be an issue with processor scheduling on the hypervisor, it depends on how your resources are configured.

http://communities.vmware.com/docs/DOC-4960

It looks fine - are you using the SQL Native Client? I don't know if any other ODBC/OLE drivers support failover partner.

CXPACKET waits are only going to apply with parallelism; you should have less issues with a lower number. If you want to reduce the waits then you reduce the...

I suspect you need to drop your MAXDOP significantly lower that 12 to see any real difference, but be aware that you could adversely affect some of your queries by...

I'm not aware of any way to get around this based on your circumstances. Did you check the wait stats / perfmon to identify the limiting factor? Assuming...

Silverfox (10/28/2009)

---

Needless to say, it was a learning curve and doubly made me very aware there is no point in trying to prep for an interview as the questions had...