• When switching to simple recovery model, you also lose the ability to perform file or filegroup or page level restores. For example, if I had a corrupted page in a database, I could restore the affected page from the full backup and then apply all of the log backups since that time to bring the page up to date.

    Nonetheless, there are definitely times when simple recovery is fine to use so long as you are aware of the ramifications.


    My blog: SQL Soldier[/url]
    SQL Server Best Practices:
    SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]