• First thing, good article Brady.

    With many topics, sometimes your going to get a lot of feedback (which is good) on little tidbits which may need "more" feeling out.

    @echatzigeorgiou

    Backups can be run at anytime but only from the Principle Servers database. Backups are basically point of time snapshots so the database goes on it's merry way while the backup occurs.

    For restoring, in mirror configuration, it's a bit more complicated. Basically you have to break the mirror, do your restore on your principle and then go through the whole process of configuring the mirror again.

    Also, to add to your article, sample connection string for using the failover in applications...

    connectionString="Network=dbmssocn;server=SQL1;Failover Partner=SQL2;Initial Catalog=YourDB;"

    It gives the application the 2 partners in the mirror to connect to if one fails. This is for when you have a witness in the mirror operation, "realtime" failover requires the witness server (which can be a simple express version of SQL)

    Also, Mirroring is database specific, any configurations for the actual SQL server (such as jobs, security, etc...) have to be manually managed between the servers.

    HTH and keep writing...

    Dave