Post reply

Is Data Mirroring supported by SQL SERVER 2005?

  • February 6, 2008 at 7:42 am

    #120568

    I know it exists in SQL Server 2005 but I read many articles that it is not working, it that true?

    If it is working in SQL Server 2005, after I create the mirror database, can I access the mirror database, that is query the table, running SSIS against it?

    Thanks

  • February 6, 2008 at 7:49 am

    #775591

    Hello Loner,

    Yes it is available in SQL 2005 and it is working.

    You can't directly query the mirror database but in fact you need to create a snapshot of the mirror database and on that you can query through SSIS as desired.

    Hope this helps.

    Thanks


    Lucky

  • February 6, 2008 at 7:58 am

    #775600

    Hi Loner,

    There's also some restrictions re: what Editions can participate as (witness, partner). Worth looking here for quick reference:

    http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx

  • February 6, 2008 at 8:03 am

    #775608

    mirroring was not supported in the RTM version. You must have at least SP1 to use and it works great, though it has limitations.

    The snapshot on mirror works well, but it is a point in time, so changes made to the source database( and mirror) after the snapshot won't show up in the snapshot.

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

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