Backup database creates smaller files....

...but from a 3+GB MDF file I obtain a .BAK of only 56 MB!!!!!!!!
Is it possible or am I crazy?
Fabri
('N patri campa centu figghi e centu figghi nun s'a firunu a campari a
'n patri.)Are you doing a differential backup and overwriting the old file?
"Fabri" <no@.sp.am> wrote in message news:d4o6ul$2cp$1@.news.ngi.it...
> ...but from a 3+GB MDF file I obtain a .BAK of only 56 MB!!!!!!!!
> Is it possible or am I crazy?
> --
> Fabri
> ('N patri campa centu figghi e centu figghi nun s'a firunu a campari a 'n
> patri.)|||It is possible and SQL Server backup doesn't backup unused storage. But also
make sure you are doing
the right type of backup etc.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Fabri" <no@.sp.am> wrote in message news:d4o6ul$2cp$1@.news.ngi.it...
> ...but from a 3+GB MDF file I obtain a .BAK of only 56 MB!!!!!!!!
> Is it possible or am I crazy?
> --
> Fabri
> ('N patri campa centu figghi e centu figghi nun s'a firunu a campari a 'n patri.)[
/color]