Skip to main content
edited title
Link
SomeGuy
  • 2.1k
  • 8
  • 35
  • 47

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

Tweeted twitter.com/#!/StackDBAs/status/443744102388338689
Source Link
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?