Solved

SharePoint Database Recovery model

Posted on 2014-09-16
2
174 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 32

Accepted Solution

by:
Jamie McAllister MVP earned 500 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

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sharepoint 2013 foundation 2 45
How can I find this data? 3 41
Need to update SSL certificate on SBS 2011 7 81
Create a  Document Management system in SharePoint 2013 2 49
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
These days socially coordinated efforts have turned into a critical requirement for enterprises.

739 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