Friday, March 30, 2012

I get confused about my MDF and LDF files against backup files

My MDF and LDF files sizes are like 100 MG each one.
We bakup the database always. When we do this, we get 5 txt files with infor
mation about the backup,
one BAK file with size like my MDF file, but we get another BAK file that ha
ve a BIG size, like 8 GB.
What happened here?I assume that you mean 100 MB, and not 100 MG.
Remember that when you backup a database, and you always use the same backup
file names, the backup files are appended onto the existing files unless you
use the INIT option. That may explain why the other file is so big. To
view the contents of each backup set within that file, use the RESTORE
HEADERONLY command.
Peter Yeoh
http://www.yohz.com
Need smaller backup files? Try MiniSQLBackup
"Rekiller" <incerbro@.cablenet.com.ni> wrote in message
news:3C6594E4-8049-413F-9705-1DAB3330519B@.microsoft.com...
> My MDF and LDF files sizes are like 100 MG each one.
> We bakup the database always. When we do this, we get 5 txt files with
information about the backup,
> one BAK file with size like my MDF file, but we get another BAK file that
have a BIG size, like 8 GB.
> What happened here?
>sql

No comments:

Post a Comment