NPM has the ability to use SQL Clustering for database redundancy. We use SQL mirroring instead of clustering. We would like to have NPM have the ability to use SQL mirrors. It would need the client to have two instances of SQL defined in the connection string. This has the ability to have auto failover in case the Primary SQL server is unavailable. Also the DBA can bring down the Primary for maintenance without loss of data.
