Veritas NetBackup™ Administrator's Guide, Volume II
- NetBackup licensing models and the nbdeployutil utility
- Creating and viewing the licensing report
- Reviewing a capacity licensing report
- Reconciling the capacity licensing report results
- Reviewing a traditional licensing report
- Additional configuration
- About dynamic host name and IP addressing
- About busy file processing on UNIX clients
- About the Shared Storage Option
- About configuring the Shared Storage Option in NetBackup
- Viewing SSO summary reports
- About the vm.conf configuration file
- Holds Management
- Menu user interfaces on UNIX
- About the tpconfig device configuration utility
- About the NetBackup Disk Configuration Utility
- Reference topics
- Host name rules
- About reading backup images with nbtar or tar32.exe
- Factors that affect backup time
- NetBackup notify scripts
- Media and device management best practices
- About TapeAlert
- About tape drive cleaning
- How NetBackup reserves drives
- About SCSI persistent reserve
- About the SPC-2 SCSI reserve process
- About checking for data loss
- About checking for tape and driver configuration errors
- How NetBackup selects media
- About Tape I/O commands on UNIX
NetBackup for SQL Server agent
Licensing for SQL Server is specific to the MS-SQL-Server policy type. NetBackup collects the data for any SQL Server backup that can be restored, not including transaction logs.
The following SQL Server queries are used to gather file size information.
Get size of entire database
Given the database name, this query gets the file size in MB, not including the transaction log:
USE <dbname>; SELECT CAST(SUM(dbfile.size) AS FLOAT) / 128.0 AS FileSizeInMB FROM sys.database_files AS dbfile WHERE dbfile.drop_lsn IS NULL AND dbfile.type <> 1;
Get size of entire database for skip read-only file groups option
Given the database name, this query gets the file size in MB for skip ReadOnly file groups option:
USE <database_name>; SELECT sysFG.name AS FileGroupName, SUM(CAST(dbfile.size AS float) / CAST(128 AS float)) AS FileSizeInMB FROM sys.database_files AS dbfile INNER JOIN sys.filegroups AS sysFG ON dbfile.data_space_id = sysFG.data_space_id WHERE sysFG.is_read_only = 0 and drop_lsn is null GROUP BY sysFG.name;
Get the size of file groups for a partial backup
Given the database name, this query gets the file size in MB for file groups that are specified in the partial list:
USE <database_name>; SELECT sysFG.name AS FileGroupName, SUM(CAST(dbfile.size AS float) / 128.0) AS FileSizeInMB FROM sys.database_files AS dbfile INNER JOIN sys.filegroups AS sysFG ON dbfile.data_space_id = sysFG.data_space_id WHERE drop_lsn is null and sysFG.name in (<delimited fg name>, ...) GROUP BY sysFG.name;
Get size of file and corresponding file group name
Given the file name (object name) and database name, this query gets the file size in MB and the corresponding file group name:
USE <database name>; SELECT sysFG.name AS FileGroupName, (CAST(dbfile.size AS float) / 128.0) AS FileSizeInMB FROM sys.database_files AS dbfile INNER JOIN sys.filegroups AS sysFG ON dbfile.data_space_id = sysFG.data_space_id WHERE dbfile.name = N'<file name>' and drop_lsn is null
Get size of file group
Given the file name (object name) and database name, this query gets the file group size in MB:
USE <database name>; SELECT SUM(CAST(dbfile.size AS float) / 128.0) AS FileSizeInMB FROM sys.database_files AS dbfile INNER JOIN sys.filegroups AS sysFG ON dbfile.data_space_id = sysFG.data_space_id WHERE sysFG.name = N'<filegroup name>' and drop_lsn is null