InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 10:14:47 GMT20http://www.sqlservercentral.com/Forums/Topic1379408-1550-1.aspx[quote][b]arnipetursson (11/1/2012)[/b][hr]Since you are going to 2008, you should be using backup compression by default.[/quote] i read somewhere that compressed backups take cmparatively high CPU (from normal backup files) during restoration.Mon, 05 Nov 2012 03:05:24 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1379408-1550-1.aspxSince you are going to 2008, you should be using backup compression by default.Since backups are more likely to be IO bound than CPU bound, you backups will be substantially smaller and somewhat faster.The amount of space savings will depend on the type of data you have in the database.Therefore, you are going to have to do this empirically after the fact.Thu, 01 Nov 2012 13:00:24 GMTarnipeturssonhttp://www.sqlservercentral.com/Forums/Topic1379408-1550-1.aspxThanks Gail.Wed, 31 Oct 2012 11:01:07 GMTsunny.tjkhttp://www.sqlservercentral.com/Forums/Topic1379408-1550-1.aspxBest bet would be to look at your normal scheduled backups, see how large they are and how long they took.Wed, 31 Oct 2012 10:05:10 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1379408-1550-1.aspxWe are going to do an upgrade from 2005 to 2008. Is there a way to estimate the size of a backup and time it might take?Wed, 31 Oct 2012 09:49:09 GMTsunny.tjk