Reputation
Top tag
Next privilege 125 Rep.
Vote down
Badges
3
Newest
 Student
Impact
~248 people reached

  • 0 posts edited
  • 0 helpful flags
  • 9 votes cast
Nov
28
comment Does it make sense to use full recovery if the data and log files are on the same HD?
you added a very good point, I just had a meeting with management and explained what were the options and we will budget for an extra drive for the SQL server to separate data and logs and also set up frequent transaction log backups so the logs don't grow indefinitely. Thank you all for the comprehensive answers!
Nov
28
accepted Does it make sense to use full recovery if the data and log files are on the same HD?
Nov
27
awarded  Student
Nov
27
comment Does it make sense to use full recovery if the data and log files are on the same HD?
this is interesting, it seems that devs messing with production dbs is a more common problem than I thought! (knocks on wood 3 times)
Nov
27
awarded  Scholar
Nov
27
awarded  Supporter
Nov
27
asked Does it make sense to use full recovery if the data and log files are on the same HD?