Post reply

Database mirroring

  • June 10, 2010 at 5:38 am

    #222493

    For sql server 2005 sp2 we have to enable the trace flag 1400 for database mirroring (or) automatically it will enable when we are going to configure database mirroring (FOR SP2)

  • June 10, 2010 at 9:24 am

    #1178674

    it wil not enable directly,manually we have to enable manually

  • June 10, 2010 at 12:37 pm

    #1178848

    Starting with SQL Server 2005 SP 1, database mirroring is available without enabling any trace flags.

  • June 24, 2010 at 1:57 am

    #1184365

    Hello Friends.......

    Database mirroring is a primarily software solution for increasing database availability. Mirroring is implemented on a per-database basis and works only with databases that use the full recovery model. The simple and bulk-logged recovery models do not support database mirroring. Therefore, all bulk operations are always fully logged. Database mirroring works with any supported database compatibility level.

    Thanks

    web development

  • June 24, 2010 at 2:00 am

    #1184367

    carolwood (6/24/2010)

    Database mirroring is a primarily software solution for increasing database availability. Mirroring is implemented on a per-database basis and works only with databases that use the full recovery model. The simple and bulk-logged recovery models do not support database mirroring. Therefore, all bulk operations are always fully logged. Database mirroring works with any supported database compatibility level.

    Nice quote.

    http://technet.microsoft.com/en-us/library/ms189852.aspx

    You should correctly attribute the source when you quote directly...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 2, 2010 at 12:38 am

    #1188020

    For enabling mirroring in SQLserver 2005 SP2 ,we need to add trace flan in startup option (try this -t(1400)),then restart the server u ll see mirroring happens.

  • July 2, 2010 at 12:59 am

    #1188025

    alokmishra0 (7/2/2010)

    For enabling mirroring in SQLserver 2005 SP2 ,we need to add trace flan in startup option (try this -t(1400)),then restart the server u ll see mirroring happens.

    You do not. Traceflag 1400 is only needed in SQL 2005 RTM because mirroring was disabled in that version. Mirroring was fully enabled in SQL 2005 SP1, hence the traceflag is not needed on a SQL 2005 server past SP1

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 7 posts - 1 through 6 (of 6 total)

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