verify a tape backup job 1

[JohnnyL]

Hi all,

I've got some TSQL statements to backup my databases to tape overnight as server jobs. Whereas the Enterprise Manager "Backup Database" option gives you the option to verify after a backup, I cant find the same argument for the T-SQL statement anywhere.

The jobs basically run...

BACKUP DATABASE [MYDB] TO [Tape0] WITH INIT , NOUNLOAD, NOUNLOAD, NAME = N'Tape0', NOSKIP , STATS = 10, NOFORMAT

If I run the backups this way, can it be verified?

Any help gratefully received.
John

 

[mrdenny]

To check the backup you do a RESTORE command it isn't part of the backup command.

RESTORE VERIFYONLY FROM BackupDevice

Look at RESTORE VERIFYONLY in books online for more info.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[JohnnyL]

Thanks mrdenny.

 

[mrdenny]

no problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com