Is the Bulk-Logged recovery model in SQL Server ever preferable to Simple if point-in-time restore is never needed? I have read many articles about transaction log models, but cannot find a clear answer to this. The database in question has a lot of activity during nightly loading, but the data doesn't change after that. I am doing a full backup daily. Wouldn't Simple be the best choice here, while also potentially using less storage?
Is bulk-logged recovery model every a good choice if point-in-time restore is not needed?
SomeGuy
- 2.1k
- 8
- 35
- 47