Forum Discussion

JustTryinToGetI's avatar
JustTryinToGetI
Level 6
12 years ago

Mismatch on "sizes" with regard to database backups

I have a SQL database on a Server. When I prepare a backup job, I am able to select the MS SQL Server Instance and I can see that the database is reported as 80GB. Yet when I run a Full backup, I look at the backup set just created, and it only shows the job as being 1.5GB.

There is no failures in the job log.

Thank you.

2012
Backing Up
Backup and Recovery
Backup Exec
Training
Windows Server (2003-2008)
  • VJware's avatar
    VJware
    12 years ago

    Possibly 1.5GB is the actual used size, whereas 80GB is the size of the container. As a test, if you enable AOFO & rerun the SQL backup, you should see 80GB (1.5 GB used space + remaining empty space)

  • VJware's avatar
    VJware
    Level 6
    12 years ago

    Possibly 1.5GB is the actual used size, whereas 80GB is the size of the container. As a test, if you enable AOFO & rerun the SQL backup, you should see 80GB (1.5 GB used space + remaining empty space)

  • pkh's avatar
    pkh
    Moderator
    12 years ago

    The important thing is not the size of the backup, but whether you can successfully restore the database.

    If you are using compression during your backup, it could account for some of the size difference.