SQL Server Performance

Backup strategy for database in Mirroring Session

Discussion in 'SQL Server 2005 Database Mirroring' started by amitadmin, May 30, 2008.

  1. amitadmin New Member

    Hi Friends,
    When failover occurs we want to enable and run the backup job on mirror which is now principal after failover.
    How do achieve this?
    [:)]I believe anyone will respond .
  2. satya Moderator

    All the jobs on mirror server which will takeover as Principal should be enabled manually, as the DB mirroring doesn't take care these issues.

Share This Page