BACKUP DATABASE [F1Settings] TO DISK = N'\Networkstorage\backupfolder\servername\MyBackup.bak' WITH NOFORMAT, NOINIT, NAME = N'MyDBBackup-Full', SKIP, NOREWIND, NOUNLOAD, STATS = 10GODECLARE @backupSetId AS intSELECT @backupSetId = positionFROM msdb..backupsetWHERE database_name = N'MyDBBackup' AND backup_set_id = (SELECT MAX(backup_set_id) FROM msdb..backupset WHERE database_name = N'MyDBBackup')IF @backupSetId IS NULL BEGIN RAISERROR(N'Verify failed. Backup information for database ''MyDBBackup'' not found.', 16, 1) ENDRESTORE VERIFYONLY FROM DISK = N'\Networkstorage\backupfolder\servername\MyBackup.bak' WITH FILE = @backupSetId, NOUNLOAD, NOREWINDGO