Changing recovery model from Full to Simple
Posted on 2006-07-12
Got a Raiser's Edge database. Sits on SQL Server 2k. It installs by default in Simple recovery, and the company doesn't support it going to Full. But I thought it would be a good idea to get those log backups going so switched it to full and set up full/differential/log backups. Today got reports that the db was going v slowly. Discovered that the log file was growing rapidly, presumably the slowness coming from the log recreating itself every time it got 10% bigger. It's up to 3 gig now. So I made an extra log backup, and stopped and restarted the server but the log is still at 3 gig.
Decided all I could do was set the db back to Simple recovery until I can find out what the problem is.
1. The log file is still 3 gig - is that to be expected after going back to Simple?
2. I thought stopping/starting the server emptied the log? Or did I dream that?
3. Any ideas what could have caused this?
4. Is there anything about going from Full to Simple that could cause any problems (beyond not being able to do log backups)?