SQL Verify from Yohz Software does all of the stuff that clubbavich mentions i.e.

- compute file checksums

- copy backup files to secondary locations

- restore backup files, and optionally run database...

After copying the model data files from a working instance and get your instance started, you could just restore from the backups you made previously.

Have you tried restoring the database using SQL Server natively, without SQL Virtual Restore, and see if you get the same error?

Differential backups? They only back up pages that have changed since the last full backup, and are cumulative. This means that you only need to restore the last...

Speeding up backups?

Looks like an error in the script/stored procedure. Suggest you debug the script/stored procedure in a query window, and use PRINT statements liberally around line 256 to see what's...

The backup process is as Steve described, except for point 3

which will depend on whether there...

Any chance it has something to do with the drive where the undo file is located, or perhaps you have some filter drivers that's intercepting the disk calls and performing...

Or run

DBCC TRACEON(3004, 3605,-1)

to get detailed progress about the restore process in your SQL Server log file.

That's certainly a big difference of 8 hours between the 2 servers to restore that transaction log. I know it's a long shot, but any chance the SQL Server...

6 hours does look like an extremely long time to create the undo file, even if the entire 5.5 GB contains uncommitted transactions. Can you compare the restore speed...

As stated by the other guys, a backup file only contains data pages that are actually used. If you run the following script:

CREATE DATABASE sizetest ON PRIMARY(NAME = 'sizetest_data',...

To add to the above, you can run this query to see exactly how much data is being backed up for your database.

SELECT database_name, backup_start_date, backup_size, compressed_backup_size

FROM msdb..backupset

WHERE...

Disclaimer: I have no experience using CommVault, and the following is only based on my experience working on SQL Backup for the last 7 years.

Is it possible that CommVault is...

GilaMonster (6/17/2010)

---

The backup process writes a checksum over the backup file, so if anything damages any portion of the backup file it will be detected if you do a restore...