177 reputation
5
bio website
location Lebanon, NH
age 27
visits member for 1 year, 8 months
seen May 1 '13 at 19:59

Sep
2
awarded  Popular Question
Apr
22
accepted .mdf vs .ldf Performance considerations
Apr
18
awarded  Scholar
Apr
18
accepted SQL Server Transaction Backups vs Logs
Apr
18
accepted Time to apply transaction logs: does it matter how many logs?
Apr
18
comment Time to apply transaction logs: does it matter how many logs?
@MaxVernon, I think you've answered the question by saying they're basically the same in terms of restore time. If you make your comment an answer I will accept it.
Apr
18
comment Time to apply transaction logs: does it matter how many logs?
Right, I know I need to restore them in order. Here's the hypothetical I'm asking about: suppose the database needs to be restored and the last full backup was 2 days ago. Will it be a lot slower if I have 5-minute transaction backups (meaning there would be 576 of them) vs 1-hour transaction backups (meaning there would be 48 larger files)?
Apr
18
asked Time to apply transaction logs: does it matter how many logs?
Apr
18
awarded  Editor
Apr
18
revised .mdf vs .ldf Performance considerations
deleted 1 characters in body
Apr
18
asked .mdf vs .ldf Performance considerations
Apr
18
awarded  Student
Apr
18
comment SQL Server Transaction Backups vs Logs
Thanks, this is very helpful. It sounds like our regular SQL Server backup plans are enough, and there is no need to tamper with the .mdf or .ldf files directly.
Apr
18
awarded  Supporter
Apr
18
asked SQL Server Transaction Backups vs Logs