Checking backup file questions

[John S]

Hi All,

I have several questions about checking backup file :

a. When SQL Server receive a command :
BACKUP DATABASE test to DISK = '\\pc1\netdb\BTEST',
does it verify BTEST file before ending the job ?
b. Is there any special command for checking / verifying
a backup file ?
c. If I send a restore command using a file infected
by a virus, what action will SQL Server take ?

Thanks in advance
John S

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Dan Guzman]

> a. When SQL Server receive a command :

BACKUP DATABASE test to DISK = '\\pc1\netdb\BTEST',
does it verify BTEST file before ending the job ?
No.

b. Is there any special command for checking / verifying
a backup file ?
You can use RESTORE VERIFYONLY to ensure the backup file format is valid
like the example below. However, this does only cursory validation. The
only way to be certain the backup is valid is to perform a test restore.

RESTORE VERIFYONLY
FROM DISK = '\\pc1\netdb\BTEST'

c. If I send a restore command using a file infected
by a virus, what action will SQL Server take ?

SQL Server will try to perform the restore but there is no telling what may
happen if the backup file was tampered with.
--
Hope this helps.

Dan Guzman
SQL Server MVP