By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,766 Members | 1,281 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,766 IT Pros & Developers. It's quick & easy.

Checking backup file questions

P: n/a
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!
Jul 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
> 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
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.