Skip to main content
1 of 2
SomeGuy
  • 2.1k
  • 8
  • 35
  • 47

Is bulk-logged recovery model every a good choice if point-in-time restore is not needed?

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?

SomeGuy
  • 2.1k
  • 8
  • 35
  • 47