Eu já fiz isso porém da erro
Segue o erro
GO
BACKUP DATABASE [PT] TO DISK = N''\\10.30.40.20\SBD02V10\PT_backup_2010_05_19_133438_7344238.bak'' WITH NOFORMAT, NOINIT, NAME = N''PT_backup_2010_05_19_133438_7344238'', SKIP, REWIND, NOUNLOAD, COMPRESSION, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''PT'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''PT'' )
if @backupSetId is null begin raiserror(N''Falha na verificação. Informações de backup do banco de dados ''''PT'''' não encontradas.'', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N''\\10.30.40.20\SBD02V10\PT_backup_2010_05_19_133438_7344238.bak'' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
Att
