Hi

My database mdf file and log file combined equate to 1.6 gig in size. Why is my bak file 89 gig? I have inherited this database so have no idea how the previous user set the backup to run -

Any pointers on either of these points would be great.

Many thanks

Rob

__________________
Rob Carter

What is your retention time?
Do you have a lot of backups in the BAK file?

I am unsure about what you mean with reagrd to retention time - if you mean how often the back up runs then it is run daily. To my knowledge only one database is backed up in the bak file, what I guess you are asking is has the previous backup been truncated before the new bak file is created - again, after inheriting the database I am unsure.

Can you help me find out?