Can we run differential backup from Net bacup Client?

[Bhaskar_Chattop]

We are new to Netbackup environment. We have a requirement to run netbackup from a client (Netbackup Server using "Veritas netbackup 5.1 MP 4") and we would like to run a differential backup on a directory on hourly basis.

Presently, we are running the following command:

bpbackup -w -p Windows -L Log_file_location -s USER_BACK_5WEEK Directory_to_be_backedup\*.trn

We take hourly transaction log backup of SQLserver (2000/2005) databases onto "Directory_to_be_backedup". We then schedule a separate job which will should run differential backup so only those files which are newly created will be backed up.

However, the above command is taking full backup of all the files of that directory.

Would appreciate any help on this.

[Rakesh_Khandelw]

User Based backups are always Full backups.

If you are using SQL agent, you may be able to achieve it by defining "DUMPOPTION INCREMENTAL" in your batch file and call it through a differential schedule from Backup server.

[Bhaskar_Chattop]

Thanks for the response, Mr. Rakesh.

Can you please elaborate little further on "DUMPOPTION INCREMENTAL"? I am a DBA, and little bit background will help us taking it more effectively with our storage Group who support Netbackup.

Is SQL Agent a separate product to be installed on the Netbackup Server?

Thanks.

[marekkedzierski]

hmm or install administration console on the client, add client to the server list on master servier, create policy with incremental schedule and run "bpbackup -i" with parameters..

[Rakesh_Khandelw]

Check this out -

NetBackup for Microsoft SQL Server System Administrator's Guide ( http://support.veritas.com/docs/279277 )

NetBackup for SQL Server extends the capabilities of NetBackup for Windows to include backing up and restoring SQL Server databases. These capabilities are provided for a Windows client using either a UNIX or Windows NetBackup master server.
NetBackup for SQL Server includes a client-based graphical user interface (GUI) program to perform various activities on SQL Server. These activities include:
◆ Setting options for NetBackup for SQL Server operations.
◆ Backing up, restoring and copying databases and database components, which include transaction logs, differentials, files and filegroups.
◆ Starting NetBackup for SQL Server operations from batch files which you have created.
◆ Monitoring NetBackup for SQL Server operations.
Microsoft SQL Server will be referred to as SQL Server. NetBackup for Microsoft SQL Server will be referred to as NetBackup for SQL Server.

NetBackup Operations
◆ Full integration with the NetBackup master server and Media Manager.
◆ Stream-based backup and restore of SQL Server objects to tape or disk using SQL Server's high-speed virtual device interface.
◆ Snapshot-based backup and restore of SQL Server objects using NetBackup Advanced Client methods.
◆ Backup and recovery of databases, differentials, files, filegroups, and transaction logs.
◆ Browse capability for SQL Server objects on the local and remote nodes.
◆ Support for redirection of SQL Server restores to different locations.
◆ Support for multiple SQL Server instances.
◆ Client operation monitoring through the NetBackup Client Job Monitor. Server monitoring is also available through the NetBackup master.
◆ Performance tuning through user control of backup stripes, transfer size, and buffer usage.
◆ Job launch is supported through the following options:
◆ Immediate launch through the NetBackup Database Extension GUI
◆ Scheduled backup in a backup policy
◆ Command line launch
◆ Support for Microsoft Cluster Server and Veritas Cluster Server.
◆ Recovery of Microsoft SQL images backed up with Backup Exec, through the Backup, Archive, and Restore (NetBackup Client) interface.
◆ Support for SQL Server 2005 enhancements, including page-level validation and partial database backup and restore.
◆ Partial recovery
◆ Optimization for read-only filegroups
◆ Verify-only restore
◆ Page verification during backup and restore
◆ Page-level restore
◆ Backup and restore of the full text search catalog
◆ Extended object information in the SQL Server catalog
◆ Progress statistics during backup and restore
◆ Copy-only backup



Yes, it is a separate product (kind of add on to NetBackup).

[Rakesh_Khandelw]

Once you add the client to server list on master server, you make the client as a trusted host (In most of the production environments it is a SERIOUS SECURITY CONCERN. It may not be for you if this is the only client you have in your NetBackup environment/domain).Message was edited by:
RK

[Bhaskar_Chattop]

Thanks Mr. Rakesh. We will review these info with our storage group.