Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 How to compute for a backup file size

Author  Topic 

JeBoy
Starting Member

7 Posts

Posted - 2008-01-09 : 02:02:33
hello guys,

Please bare with my english.

Is there a way to compute for the backup file size of the database.
Example.

DatabaseName
TEST_DB

*in MB
DataSize DataSize_Used DataSize_UnUsed
150.00 81.00 70.00

LogSize LogSize_Used LogSize_UnUsed
30.00 1.00 29.00


When I run a backup for TEST_DB ,
*base on this figure - can we compute the the estimated backup file size for TEST_DB?

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2008-01-09 : 02:46:32
test your theory and see


-ec
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-01-09 : 23:15:42
Will be around 81gb with native sql backup.
Go to Top of Page
   

- Advertisement -