SQL Server Performance

Schema changes on princicpal

Discussion in 'SQL Server 2005 Database Mirroring' started by LeClair, Jun 7, 2007.

  1. LeClair New Member

    I've got an instance of high-performance mirroring setup, but I need to make some schema changes to the principal database.
    I can't find any documentation on the procedure here...will schema changes made on the principal get sent to the mirror? Or will I need to recreate the mirror by making a new backup?

    Any thoughts are appreciated.
    thanks
  2. satya Moderator

    Schema changes are logged operations and such operations will automatically applied to mirror database too.


    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  3. MohammedU New Member

    quote:Originally posted by LeClair

    I've got an instance of high-performance mirroring setup, but I need to make some schema changes to the principal database.
    I can't find any documentation on the procedure here...will schema changes made on the principal get sent to the mirror? Or will I need to recreate the mirror by making a new backup?

    Any thoughts are appreciated.
    thanks
    As Satya mentioned, you don't need to take any special considerations for schema changes when you are mirroring the db...
    May be you are thinking of replication but in 2005 schema changes can be replicated...

    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

Share This Page