118 reputation
3
bio website flickr.com/photos/bubbassauro
location New York, NY
age 33
visits member for 1 year, 8 months
seen Mar 24 at 15:20

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?