X hits on this document

485 views

0 shares

0 downloads

0 comments

141 / 200

Using NetBackup for SQL Server with Snapshot Client How SQL Server operations use Snapshot Client

When you launch the restore operation, notice that the batch file specifies both the name of the storage image and the name of the backup image. (See the figure below.)

Storage image name and backup image name are shown when restoring from a grouped backup.

Using copy-only or cloaked snapshot backups to impact how differentials are based (SQL Server 2000 and SQL Server 2005)

SQL Server records the history of successful database backups in the MSDB system database. It uses this history in deciding how to base differential backups. In particular, SQL Server creates differential database backups as cumulative with respect to the last full database backup that it has recorded in the MSDB. This allows for a quick recovery in case a failure has been detected after the last full database backup.

For example, assume that full backups are created every day at midnight; differentials are created every day at 6AM, noon, and 6PM; and transaction log backups are created every two hours. If a failure occurs at 7:50PM on Tuesday,

141

Document info
Document views485
Page views485
Page last viewedWed Dec 07 12:31:14 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments