Database size different in Backup Exec

Posted on 2007-10-20
Last Modified: 2009-07-29
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

Question by:Nirav04
    LVL 9

    Accepted Solution

    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
    LVL 1

    Author Comment

    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
    LVL 1

    Expert Comment

    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.
    LVL 1

    Author Comment

    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.

    LVL 1

    Author Comment

    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/
    LVL 1

    Expert Comment

    Thank you so much for the info.  I assumed this to be the case but now I can stop sweating bullets!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
    I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now