Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Backup size estimation Expand / Collapse
Author
Message
Posted Wednesday, October 31, 2012 9:49 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 3:00 PM
Points: 298, Visits: 1,099
We 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?
Post #1379408
Posted Wednesday, October 31, 2012 10:05 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 7:46 AM
Points: 42,756, Visits: 35,846
Best bet would be to look at your normal scheduled backups, see how large they are and how long they took.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1379413
Posted Wednesday, October 31, 2012 11:01 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 3:00 PM
Points: 298, Visits: 1,099
Thanks Gail.
Post #1379447
Posted Thursday, November 1, 2012 1:00 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 10:29 AM
Points: 272, Visits: 848
Since 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.
Post #1379983
Posted Monday, November 5, 2012 3:05 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 12:26 AM
Points: 2,840, Visits: 3,963
arnipetursson (11/1/2012)
Since you are going to 2008, you should be using backup compression by default.
i read somewhere that compressed backups take cmparatively high CPU (from normal backup files) during restoration.


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1380946
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse