Backup Sizes in Taskpad and Best Practice

Quick question, does anyone know how the backup size of a database is
determined? I am trying to calculate particular size of a database and its
backup size.
SQL Server 2000 database has many types of size calculations, for example
A. Under Properties -- General Tab
1. Size: 124800.78MB
2. Space Available: 64001.71 MB
B. Under Properties -- Data Files Tab
1. Space allocated: 104013 MB
2. Space allocated: 20789 MB
C. Under Taskpad -- General
1. Data: 104012.56MB | 60445.12MB (Used)| 43567.44MB (Free)
2. Transaction Log space: 20788.49MB | 69.09MB (Used)| 20719MB (Free)
How do I know the size of the database backup given the info above? What do
people usually practise to minimize the backup size while not impeding the
performance and availability?
Thanks,
C TOA is the combined physical file sizes of data and log files on teh drive
B is is individual physical file sizes
C shows how much of the lhysical file size is being used by data
I just checked one of my backups and it appears to be the size of my actual
data for both files, not the size of the physical files, which makes sense.
If you want to minimize the size of you backup files as well as the time it
takes, look into a product called SQL Litespeed from Imceda (yes, I am a
reseller, and for good reason)
HTH,
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"C TO" <CTO@.discussions.microsoft.com> wrote in message
news:B28AE393-46E0-49D4-8B59-52DF29ED813A@.microsoft.com...
> Quick question, does anyone know how the backup size of a database is
> determined? I am trying to calculate particular size of a database and its
> backup size.
> SQL Server 2000 database has many types of size calculations, for example
> A. Under Properties -- General Tab
> 1. Size: 124800.78MB
> 2. Space Available: 64001.71 MB
> B. Under Properties -- Data Files Tab
> 1. Space allocated: 104013 MB
> 2. Space allocated: 20789 MB
> C. Under Taskpad -- General
> 1. Data: 104012.56MB | 60445.12MB (Used)| 43567.44MB (Free)
> 2. Transaction Log space: 20788.49MB | 69.09MB (Used)| 20719MB (Free)
> How do I know the size of the database backup given the info above? What
> do
> people usually practise to minimize the backup size while not impeding the
> performance and availability?
> Thanks,
> C TO