RESTORE VERIFYONLY |
Restauration de la vérification seulement |
|---|---|
| Microsoft SQL Server |
Syntaxe
|
RESTORE VERIFYONLY FROM backup_device [ ,...n ] [ WITH { LOADHISTORY | MOVE 'logical_file_name_in_backup' TO 'operating_system_file_name' [ ,...n ] | FILE = { backup_set_file_number | @backup_set_file_number } | PASSWORD = { password | @password_variable } | MEDIANAME = { media_name | @media_name_variable } | MEDIAPASSWORD = { mediapassword | @mediapassword_variable } | { CHECKSUM | NO_CHECKSUM } | { STOP_ON_ERROR | CONTINUE_AFTER_ERROR } | STATS [ = percentage ] | { REWIND | NOREWIND } | { UNLOAD | NOUNLOAD } } [ ,...n ] ] [;] backup_device ::= { { logical_backup_device_name | @logical_backup_device_name_var } | { DISK | TAPE | URL } = { 'physical_backup_device_name' | @physical_backup_device_name_var } } |
Description
Cette instruction permet de vérifier la sauvegarde mais sans la restaurer, vérifier que l'ensemble de copie de sauvegarde est complet et que la copie de sauvegarde est complètement lisible.
Dernière mise à jour : Vendredi, le 19 Juin 2020