CODEWITHSUNDEEP
sql-serversharepointsql-server-2012sql-server-2014
Mozhgan Farhadizadeh
Mozhgan Farhadizadeh

Reputation: 11

Reason of using full recovery model for database

I use SQL Server and want to know that what are reasons that we may choose full recovery model?

For example I know that when we want to use CDC, or Mirroring must set our database recovery mode to full.

EDIT :

databases of SharePoint are full recovery mode. Can I change them to simple?

Thanks in advance.

Upvotes: 0

Views: 848

Answers (2)

Justin Russell
Justin Russell

Reputation: 488

It is safe to change the SharePoint databases (admin, service, and content) recovery model to Simple if you have no need for Full in your environment. Use the same decision making process for the recovery model of SharePoint databases as you would for any other database.

The following TechNet article covers the backup and restore best practices in SharePoint (2010 and 2013):

http://technet.microsoft.com/en-us/library/gg266384(v=office.15).aspx

Upvotes: 1

mehdi lotfi
mehdi lotfi

Reputation: 11601

Some of reason was these:

  • CDC (Change data capture)
  • Point in Time
  • Database Mirroring
  • Log shipping
  • Create Transaction log backup (for critical data)

Upvotes: 0

Related Questions