locked
A read-0nly Sharepoint farm RRS feed

  • Question

  • Is it possible to setup a sharepoint farm to be read-0nly? Such as in the case of a hot-stand-by farm? 
    Sunday, November 7, 2010 2:30 AM

Answers

  • From SharePoint 2007 Service Pack 2 on, you can set the databases to Read Only in SQL Server and SharePoint will then treat all users as "Visitors / Read Only" users.  This would need to be done as part of the fail-over process as the databases need to be read/write while they are sync'd.

     


    Mike Smith TechTrainingNotes.blogspot.com
    • Marked as answer by Seven M Thursday, November 18, 2010 8:48 AM
    Sunday, November 7, 2010 3:54 PM

All replies

  • Hi Petarch,

       A common way to provide such high availability is through the use of virtualization.  If properly configured both VM Ware and Hyper-V hosts can failover virtual machines from one physical host to another.  Furthermore, using a disk replication technology such as the technology offered by NetApp make it is possible to replicate your virtual machines to a disaster recovery (DR) site.  Should the need arise you would power up the VMs at the DR Location

    • Edited by dbottjer Sunday, November 7, 2010 4:08 AM Fix Spelling Mistake
    Sunday, November 7, 2010 4:06 AM
  • Sunday, November 7, 2010 5:10 AM
  • Thanks, but what I am concern about is to whether allow the DR site to be updated after failing over, coz if we do, then we need to sync things back to production when it is back up.

    If we set the DR farm as read-0nly, then things would probably be easier. Or can we alllow peole to work on DR and later backup/restore the DR to production?

    Sunday, November 7, 2010 7:45 AM
  • But using solutions like NetApp, do we need both Production and DR to be VMs? We plan to use real hardware for production for best performance.

    And if we are using VMware, can we use vMotion instead of NetApp? Are there any difference between VMware vMotion and NetApp?

     

    Sunday, November 7, 2010 7:47 AM
  • From SharePoint 2007 Service Pack 2 on, you can set the databases to Read Only in SQL Server and SharePoint will then treat all users as "Visitors / Read Only" users.  This would need to be done as part of the fail-over process as the databases need to be read/write while they are sync'd.

     


    Mike Smith TechTrainingNotes.blogspot.com
    • Marked as answer by Seven M Thursday, November 18, 2010 8:48 AM
    Sunday, November 7, 2010 3:54 PM