Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SharePoint Database Recovery model

Posted on 2014-09-16
2
Medium Priority
?
189 Views
Last Modified: 2014-09-17
There are several SQL Transaction log that occupy a lot of spaces. Will there be any harm if I change the SQL database to "Simple" Model ? Tks

SharePoint_AdminContent_ebdfeb9b-45e4-41d2-943e-0362e2243317_log
WSS_Logging
Search_Service_Application_CrawlStoreDB_5f56f67459e440159489bb503a0c1259_log
StateService_2df6c60250144ab0bed581fb30138d93_log
WebAnalyticsServiceApplication_ReportingDB_c45dc0c4-1a3f-451a-926c-0b46083a4bd1_log (> 23GB)
WebAnalyticsServiceApplication_StagingDB_8241a817-1f54-4a56-a0ec-82002aeeeb98_log  (> 15GB)
StateService_2df6c60250144ab0bed581fb30138d93_log
0
Comment
Question by:AXISHK
2 Comments
 
LVL 32

Accepted Solution

by:
Jamie McAllister MVP earned 2000 total points
ID: 40327413
It changes the point at which you can backup to. Meaning you can backup to the last time a Full Backup was taken in Simple mode. That said, this is done quite often due to the log file size issues you've experienced.

Check out this thread and the links referenced;

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/ed52d75c-cf23-4c61-aff4-ec158a635472/switching-configuration-database-full-to-simple-recovery-mode?forum=sqldisasterrecovery
0
 

Author Closing Comment

by:AXISHK
ID: 40329452
Tks
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

577 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question