meta user
network profile
| bio | website | flickr.com/photos/bubbassauro |
|---|---|---|
| location | New York, NY | |
| age | 32 | |
| visits | member for | 5 months |
| seen | Dec 1 '12 at 2:35 | |
| stats | profile views | 0 |
|
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? |
