Friday, October 15, 2010

RESTORE VERIFYONLY In SQL Server 2005

RESTORE

Usage:

RESTORE VERIFYONLY FROM  DISK = 'C:\www\EMP_backup_201010130110.bak'

Out Put:
The backup set on file 1 is valid. 


VERIFYONLY  is used to check wether our backup is working or not. this is not 100% but upto some extent we can conclude that our backup works fine.

No comments:

Post a Comment