Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Hard to explain in the title, but I'm planning a migration from SQL Server 2000 databases to SQL Server 2008 R2. The databases are under 100GB total space, but this is only with the Simple recovery model. I'd like to migrate, then change to full recovery model.

So, my question is: how much disk space will I need? Obviously I know there is some amount of opinion here, but what are the common ways of calculating this?

share|improve this question
3  
It all depends on how often you plan on taking transaction log backups combined with how many logged transactions are happening between backups. –  Thomas Stringer Jan 25 '13 at 16:24
7  
2  
And whether you are placing the backups and log backups on the same set of disks or elsewhere - usually you provision those separately, and even if you back up locally and then move off, the local requirement will be less but still vary depending on database growth and log activity. Still, knowing only the size of your databases and nothing about the activity, the only possible answer is "it depends." –  Aaron Bertrand Jan 25 '13 at 16:33
    
@ThomasStringer -Any suggestions on how I can estimate that? –  MAW74656 Jan 25 '13 at 16:46
2  
A good start would be to turn on full on your current system and see what the log file sizes are given a typical workload cycle and what your log frequency will likely be on the new system. –  Aaron Bertrand Jan 25 '13 at 16:55

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.