Post reply

calculate backup size

  • March 13, 2004 at 12:08 pm

    #107787

    Anyone knows how to calculate backup size and predicate backup size growth?

  • March 13, 2004 at 1:02 pm

    #498669

    Typically SQL Server backups are slightly smaller than

    the actual database size - space available.

     

     

    Give me a fish, you feed me for a day! Teach me to fish, you feed me for a life time.

  • March 14, 2004 at 7:26 pm

    #498689

    You can run sp_spaceused for the database and the reserved value in the sp_spaceused output indicate the space used. The size of the backup will usually be the size of the reserved value plus some overhead. Please note that you have to run dbcc updateusage or sp_spaceused with @updateusage = true for the stored proc to give an accurate estimate of spaceused.

  • March 15, 2004 at 1:47 am

    #498717

    You might try the Database Maintenance Plan Wizard built-in to EM and-or the sqlmaint.exe command line tool. I think these will post the size information you might be desiring in the job history information as well as to the optional log created by the tool. Allot depends on your backup and recovery needs in order to determine capacity information.Peter Evans (__PETER Peter_)

  • March 15, 2004 at 7:40 am

    #498746

    If it is an existing database, you can get history about data file and actual data growth from backup history.  See http://www.sqlservercentral.com/scripts/contributions/901.asp

  • March 16, 2004 at 4:48 am

    #498926

    Hello lila; your script on http://www.sqlservercentral.com/scripts/contributions/901.asp works fine, except for a little error in the column name "BackupSizeInGB". It should be "BackupSizeInMB", I think.

    Bert

  • March 16, 2004 at 10:56 am

    #498999

    Thank you very much. Help a lot from you guys. Any ideas why the reserved value in sp_spaceused is very close to the backup size? In my case, the reserved values always are a little greater than the backup sizes.

  • March 17, 2004 at 6:41 am

    #499104

    Thanks Bert!  The collumn name has been changed.

  • March 17, 2004 at 7:17 am

    #499112

    Frank

    The backupsize and the 'reserved' space in sp_spaceused is the actual space currently used (where datapages are written on)  -  the rest is just reserved and is really empty space and therefore does not add to volume of backed up data.

  • March 17, 2004 at 9:39 am

    #499153

    Anyone know why the differential backup size is close to full backup size after run sp_spaceused with @updateusage = true ?

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply