locked
What is DataBase Mirroring in SQL Server 2005/2008 RRS feed

Answers

  • >>>>Alteration on New Database should not refelect on Production Database but any alteration on Production Database should refelect on  New >>Database.

    No, it won't work, consider upgrading to SQL Server 2012 (AlwaysOn feature)


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

    • Marked as answer by Maggie Luo Friday, May 4, 2012 3:55 AM
    Thursday, April 19, 2012 10:54 AM
  • This can be achieved by SQL server 2012 (HADR).,

    In this senario the only feature u can use is Backup and Restore.


    Mohd Sufian www.sqlship.wordpress.com Please mark the post as Answered if it helped.

    • Marked as answer by Maggie Luo Friday, May 4, 2012 3:55 AM
    Thursday, April 19, 2012 1:09 PM
  • I don't see how you could achieve that at all, except with Backup/Restore. You say changes in Prod should be reflected on the secondary, but changes on the secondary should not be reflected in prod. Now consider you drop a table on the secondary and afterwards you insert into this table in prod. How should SQL reflect that insert? Or even easier: Consider deleting a record on Secondary and then updating that record on production. What should the system do with that?

    Your only answer will be Backup/Restore unfortuantely.

    • Marked as answer by Maggie Luo Friday, May 4, 2012 3:55 AM
    Friday, April 20, 2012 8:59 AM

All replies

  • Database Mirroring would suffice your requirement. In Database Mirroring, secondary database which is termed as mirror database is a hot standby & can't accept client connection.

    As per your requirement, you could explore replication as your option because in logshipping also secondary database wouldn't be available for alteration. You can use logshipping's secondary database for reporting purpose ONLY because there is an option to configure it as read-only.

    Hope that helps.

    Thursday, April 19, 2012 10:35 AM
  • >>>>Alteration on New Database should not refelect on Production Database but any alteration on Production Database should refelect on  New >>Database.

    No, it won't work, consider upgrading to SQL Server 2012 (AlwaysOn feature)


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

    • Marked as answer by Maggie Luo Friday, May 4, 2012 3:55 AM
    Thursday, April 19, 2012 10:54 AM
  • hi Kumar,

    Please correct me if i misunderstood your requirment.

    First of All Replication,Mirroring Log shipping ,Clustring are Scalability and availbility options. Using a canon to shot asparrow is not recomended..

    If you are setting only a test database on test server and have bear time then you can simply restore the production database backup on daily bases on test server for testing purpose/or you can use some third party utility to copy data base from Production to test.

    Hope it will help you.


    Ali Maqbool | MCTS | If you find my reply useful in any way, please vote it as helpful. If it has helped answer your question, please mark it as Answer.

    Thursday, April 19, 2012 12:40 PM
  • This can be achieved by SQL server 2012 (HADR).,

    In this senario the only feature u can use is Backup and Restore.


    Mohd Sufian www.sqlship.wordpress.com Please mark the post as Answered if it helped.

    • Marked as answer by Maggie Luo Friday, May 4, 2012 3:55 AM
    Thursday, April 19, 2012 1:09 PM
  • I don't see how you could achieve that at all, except with Backup/Restore. You say changes in Prod should be reflected on the secondary, but changes on the secondary should not be reflected in prod. Now consider you drop a table on the secondary and afterwards you insert into this table in prod. How should SQL reflect that insert? Or even easier: Consider deleting a record on Secondary and then updating that record on production. What should the system do with that?

    Your only answer will be Backup/Restore unfortuantely.

    • Marked as answer by Maggie Luo Friday, May 4, 2012 3:55 AM
    Friday, April 20, 2012 8:59 AM