07-18-2010 08:49 PM
Solved! Go to Solution.
11-02-2010 10:24 PM
upgraded sql client and master server to 7.0.1 and sql backups using NBU is working ok.
07-18-2010 09:34 PM
This section in the NBU Admin Guide I is true for all snapshot backups - VSP and VSS:
Using VSP with databases
Consider the following information regarding using VSP (Volume Snapshot Provider) to back up and restore databases. Some database vendors provide a formal application program interface specifically designed for use with backup products. Symantec works with many database vendors to ensure that these interfaces are stable, efficient, and reliable when used with NetBackup and NetBackup database extension features. Many of these APIs were jointly developed to ensure that data is protected and can be restored when needed. Oracle, Microsoft (SQL Server, Exchange), IBM (Lotus Notes, DB2), NCR (Teradata), Sybase, and Informix are examples of the database vendors that provide an API for use with backup products. Symantec recommends using the NetBackup database extension features when a backup API is available and when a database needs to be backed up in a hot mode.
Databases with an API
Hot backups are performed on active databases. Use a formal API to create a confident backup and the ability to perform a successful restore. Symantec does not recommend using VSP for hot backups of these databases.
Cold or inactive backups of these databases may be possible with VSP, but success varies with each database vendor. Contact the specific database vendor to identify the recommended method for database backup where data reliability is ensured. Database programs recover from a point-in-time restore differently. If the data does not conform to the backup specification that is designed into the database product, the integrity of the database is questionable.
***************************************************************************************
There are 3 choices when it comes to database backups:
1. Use database agent for hot, online backups.
2. Use built-in SQL backup to backup to disk. Backup these disk backups with normal file system backups. (Lots of disk space needed, 2-phase backup, 2-phase restore)
3. Shutdown database and do normal filesystem backup.
07-18-2010 11:20 PM
07-19-2010 01:09 AM
07-19-2010 02:30 AM
07-19-2010 02:46 AM
07-19-2010 03:28 AM
11-02-2010 10:24 PM
upgraded sql client and master server to 7.0.1 and sql backups using NBU is working ok.
11-17-2010 09:14 PM
I also want to try it out. Could you please share the procedure to setup hot backup for SQL database.
In my case the challeging part is that when my SQL processing is going on or overlap backup window time then either it is affecting the SQL process or Log file in increasing which is killing Hard disk space. In this case many time I am facing problem taking backup of large DBs.
Some DB sizes are 2-3TB and Daily processing of client is forcing me to minimize backup window.
Waiting for your quick reply.
Thanks
11-17-2010 09:27 PM