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 2000 Forums
 SQL Server Administration (2000)
 Backup Size and Time

Author  Topic 

emansour
Starting Member

1 Post

Posted - 2007-02-10 : 07:55:59
Hi All,

I have setup my SQL Server database. and still no data exist. i need to do forecasting for my data backup.
my question is How can i specify number of tapes (any data calculations ?) needed and How long will a backup take (backup schedule).

Note : I have 20 users to start with , and my data for patients medical records with images.

Thanks for all.

ehab mansour

Kristen
Test

22859 Posts

Posted - 2007-02-10 : 09:05:47
It depends ...

You could calculate average record and index sizes, and that would tell you the backup size - at least approximately.

See

estimating database size
estimating database backup size

in BoL

Kristen
Go to Top of Page
   

- Advertisement -