Contents

Introduction
About SQL Verify
Version history
Contact us
User Guide
Installation
Software components
Jobs
Job types
Common job properties
Verify, restore, check database
Compute MD5 hash
Copy files
Delete files
FTP - upload files
FTP - download files
Run DBCC CHECKDB
Run command line application
Run SQL script
Grouped jobs
Use cases
Use case 1
Use case 2
Use case 3
Use case 4
Preparing to log ship a database
Notifications
Setting up notifications
Tags in SQL Verify
How reliable is RESTORE VERIFYONLY
Why checksums
Using SQL Server Express Editions
Reference Guide
Errors view
Job list view
Notifications view
Registering

 
Home
SQL Verify - Online help
Prev Page Next Page
 
 

Use cases

Here are some common use case scenarios for SQL Verify, and how to go about setting up the jobs to perform the necessary tasks.

· Use case 1 - Copy backup files to a file server, and check the recoverability of the backup files  
 
usecase1  
 
· Use case 2 - Copy backup files off-site (related to scenario above)  
 
usecase2  
 
· Use case 3 - Recompute checksum for backup files and compare against known valid values (related to scenario above)  
 
usecase3  
 
· Use case 4 - Restoring transaction logs and checking database consistency  
 
usecase4