locked
Mirroring RRS feed

  • Question

  • Hello,

    I have Microsoft SQL SERVER 2005 installed in my system.

     

    To try out mirroring, I rightclicked on the database went to the tasks, but i found that in Status its written

    "This database has not been configured for mirroring"


    What shall I do now?
    Wednesday, August 22, 2007 2:53 PM

Answers

  • I think there are 2 possibilities,

     

    1. You have Sql server RTM.......Microsoft supports mirroring from Sql 2005 SP1.......with RTM also you can configure mirroring but prior to that you need to start sql server with Trace flag -T1400 and then proceed with mirroring.

    2. You need to take full backup and one transactional log backup  in principal server and restore it in mirror server using the option WITH NORECOVERY for both the full backup and tran log backup.............then start configuring mirroring it will work perfectly...........

     

    refer these links for mirroring,

    http://sql-articles.com/articles.php?pageNum_alltop=3&totalRows_alltop=35

     

    http://sql-articles.com/articles/dbmrr.htm

     

    Revert if you need any more help............

    Thanxx

    Deepak

    Wednesday, August 22, 2007 3:12 PM

All replies