Home Forums SQL Server 2005 Backups Does a new stored procedure get created on the mirror RE: Does a new stored procedure get created on the mirror

  • Try to think through where the object is being created..... Any object created in the database will be mirrored.

    The main gotcha here are Security Principals, eg. Logins. These are not created in the database, and are thus not mirrored across. This can cause big problems after a failover.

    Andy