We are moving from SQL 2005 Enterprise x64 to SQL 2008 Enterprise X64 next week. Our Navision version is NAV 2009 executables & NAV 5.0 codebase.
I have done some testing in regards to back ups and restores and feel I must share the results.
We have a 111 gb database. A normal backup takes 25 minutes (and the size is 111 gb). Using the new SQL 2008 Compressed backup it not only reduces the backup time to 8 minutes but the backup file ends up being 20 gb!
Even crazier is that when I restore a compressed backup it takes only 5 minutes!!!
Does anyone know of any reason why I shouldn't upgrade to SQL 2008?