Discussion: SharePoint Content Database status:read only and offline

We knowSharePointrelies onSQL Serverof theContent Databaseto do data storage, but some companies have many requirements for managing data:Content Database 1only store customer information related toSite Collection; stored in someContent Databaseunder theSite Collectiondata can only be read and not written and so on, so in the face of these needs, we need to understand the preciseContent Databaseof theStatusand how to set it up?

Content Database of the Status points 2 Clock: Read only , Offline , Ready .

• Read only: IfContent Database Statusto beRead only, the description is stored in thisContent Databaseunder theSite Collectionno write permission, only read, in other words onlyViewpermissions, note: This state ofContent Databaseis inSQL ServerThe following steps are provided:

1. links SQL Server Instance , select the specified Content Database , right-click Properties as shown in the following:

1. in the Properties page, select Options , find Database read-only set to True as shown in the following:

• Offline: IfContent Database Statusto beOffline, the description is stored in thisContent Databaseunder theSite Collectionhave read and write permissions, but cannot store the newly createdSite Collection, note: This state ofContent Databaseis inSharePoint Central AdministrationThe following steps are provided:

1. in the SharePoint Central Administration page, enter application Management->manager Content Databases , toggle the corresponding WEB Application as shown in the following:

1. Select the specified Content Database , in Content Database Status Select Offline as shown in the following:

• Ready: IfContent Database Statusto be Ready, the description is stored in thisContent Databaseunder theSite Collectionread-write permission, and you can also add the newly createdSite Collectionstored in theContent Databasethe next.

Description: If you want toCentral AdministrationSet theContent Databaseof theStatuseffective, provided that the condition isSQL Serverof theContent Databaseof theStatusof theRead onlystatus is set toFalse.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Discussion: SharePoint Content Database status:read only and offline