Forum Discussion

aviltauro's avatar
aviltauro
Level 4
10 years ago
Solved

Netbackup & MS SQL Reserved Settings

I have set my MS SQL DB file size as reserved settings, 500GB instead of auto grow. Now when I take the image backup, Netabckup treats this as 500GB space even though the actual db file has not even reached 10GB. Is there any way to overcome this solution?

7.6
Backing Up
Backup and Recovery
Features
NetBackup
Windows Server (2003-2008)
  • GulzarShaikhAUS's avatar
    GulzarShaikhAUS
    10 years ago

    Hi,

    What size did you setup on the Initial size? If you setup it up as 100GB then it will create full 100GB .mdf file. Please confirm. 

    If you have setup the initial size as 100GB then Netbackup will backup the whole 100GB. But if you have MSDP/Netbackup appliance then dedupe will eventually store only the data used by the database.

6 Replies

  • Marianne's avatar
    Marianne
    Level 6
    10 years ago

    Not NetBackup - MS SQL.

    If you are doing agent backup, SQL collects and sends data to NBU.
    SQL will backup 500GB db.

  • GulzarShaikhAUS's avatar
    GulzarShaikhAUS
    Level 6
    10 years ago

    Hi,

    What size did you setup on the Initial size? If you setup it up as 100GB then it will create full 100GB .mdf file. Please confirm. 

    If you have setup the initial size as 100GB then Netbackup will backup the whole 100GB. But if you have MSDP/Netbackup appliance then dedupe will eventually store only the data used by the database.

  • Michal_Mikulik1's avatar
    Michal_Mikulik1
    Moderator
    10 years ago

    Hello,

     

    I am a bit confused that you "take the image backup". Which backup, which type of policy did you use? Then size of MSSQL database backup depends on it:

    MS-SQL-Server policy type without "Perform snapshot backup" attribute - size of backup corresponds to actual data size, not datafile size

    MS-SQL-Server policy type with "Perform snapshot backup" attribute - size of backup corresponds to actual datafile size

    VMware with "Enable SQL Recovery" - with default, corresponds to allocated data in all VMDK's with mapping info about MSSQL datafiles.

     

    Rgds

    Michal

     

  • aviltauro's avatar
    aviltauro
    Level 4
    10 years ago

    MS SQL is setup with a db of initial size as 100GB, no autogrow selected. I am using Netbackup 7.6 on Windows and the backup is normal bare metal backup.

  • Marianne's avatar
    Marianne
    Level 6
    10 years ago

    As per SymGuy-IT's post over here  - NBU will backup full size of .mdf in the file system.

    File-level backup of SQL db's should only be done with SQL services stopped.

    Perform online, hot backups of db's using the MS-SQL agent.