Post reply

Mirroring

  • December 4, 2006 at 10:03 am

    #171488

    I want to setup database mirroring between to SQL2k5 partner servers with a SQL2k5 Express witness server. One of the databases I want to mirror has numerous tables with identity fields as the primary key.

    Does anyone have any advice that could help reduce my headaches?

    Thanks

  • December 5, 2006 at 6:03 am

    #675794

    Why would identity fields give you a headache with mirroring? They require no special handling.

    Also, you posted in the wrong forum. Database mirroring is not a type of replication.

    My blog: SQL Soldier[/url]
    SQL Server Best Practices:     SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply