backup question

Is it possible as an example assuming hardware is identical and the only
thing running is Full backups that one database of say 100 GB runs for an
hour whereas another database could run for 3 hours.
Is the backups dependent upon maybe the type of data in the database ?Interesting question..
The backup should simply read the mdb files, and copy it to tape. Then it
will read the log and backup any changes made since the full backup
began...Backup ONLY backs up real data however, and not the empty space in
the files. Just because the physcial file is 100 GB, doesn't mean there is
100 GB of data... Compare the backup file sizes... One could be backing up
lots of data, and the other only a small amount... even if both contained
only 10 GB of data in the 100GB file... The data in one database could be
compressed near the front of the file ( causing minimum disk io) while the
other dB could have it's 10 GB of data spread evenly across the entire 100
GB physical file ( causing 10X more IO.)
hope this helps..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:u71QVDCNFHA.1308@.TK2MSFTNGP15.phx.gbl...
> Is it possible as an example assuming hardware is identical and the only
> thing running is Full backups that one database of say 100 GB runs for an
> hour whereas another database could run for 3 hours.
> Is the backups dependent upon maybe the type of data in the database ?
>