Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 165
  • Last Modified:

Database size different in Backup Exec

Hi, I like to find out if I am doing this right way I am running full backup of SQL 2005 database everynight when I view the database size in Backup Exec it showing 800MB but when I go to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data and look at database file its showing 8GB can you tell me if I am doing something wrong and do I need to perfom any daily maintenance.

OS: Windows 2003 Datacenter 64bit
SQL: 2005
Backup: Backup Exec 11d

Thanks,
0
Nirav04
Asked:
Nirav04
  • 3
  • 2
1 Solution
 
the_b1ackfoxCommented:
1) You're not backing up the mdf and ldf files right?  You're backing up the bak file from database maint. plans right?

2)  The size when a database is attached and active includes empty space in addition to the actual data stored in the database.  When the file is backed up to file the empty space is not included.

So it doesn;t sound like your doing anything wrong to me, as long as #1 is true
0
 
Nirav04Author Commented:
I am using SQL Agent for Backup Exec, so I am not selecting any particular file following are the options
1. Full - Backup entire database or filegroup
2. Log - backup up transaction log
3. Log no truncate - backup transaction log no truncate
4. Differential - backup database or filegroup changes only
5. Database Snapshot (SQL 2005) - Read only, point in time copy of another database
6. Full copy only (SQL 2005) - Backup entire database or filegroup without affecting future differential
    or log backup

I am selecting option 1. Full backup
0
 
damien1234Commented:
I too am experiencing exactly the same problem.  Backup exec reports a database size of 40Mb when the actual size is 2.5 GB.  Free space in the database is only 300Mb so at a bare minimum Backup Exec should report 2.2 GB.

I have installed all service packs.  SQL is on a remote server.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Nirav04Author Commented:
I am not getting response here so i will be calling Symantec to find out and understand the issue, hopefully they can help. I will update tomorrow.

0
 
Nirav04Author Commented:
I did talk to Symantec tech support regarding size, and they said its a software glitch which does not report correct size but data is backed up/
0
 
damien1234Commented:
Thank you so much for the info.  I assumed this to be the case but now I can stop sweating bullets!
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now