Search This Blog

Tuesday, April 23, 2013

Sharepoint SQL db recovery model: full vs simple

There is certain issue in the logic of recovery model of SP: the recommendation is to use full recovery,  as it keeps transaction log data,  instead of simple. However,  if you use  Sharepoint backup the log never gets flushed.  And so it keeps growing,  until you run sql backup log command. But since you already did full db backup,   the backup log file is actually not needed and can be deleted.  Work of Sisyphus... The way out is to use simple mode, although it not recommended.  Anyway talk to you dba...

2 comments:

john bell said...

I have recovered the sql database file by using the sql database recovery tool. This tool gives me so many options for sql database recovery.

Stanley D. Middleton said...

Get Sql Database Repair Tool that can easily repairs corrupt tables, triggers, views, and XML data types etc. It also allows to the export recovered SQL database directly to the SQL Server. Try from here: – http://www.filesrecoverytool.com/sql-database-repair.html