BACKUP DATABASE [sj6webdb] TO  DISK = N'D:\fes\SQLBackup\sj6webdb\sj6webdb.bak' WITH NOFORMAT, INIT,  NAME = N'sj6webdb-完全 データベース バックアップ', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N'sj6webdb' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N'sj6webdb' )
if @backupSetId is null begin raiserror(N'確認に失敗しました。データベース ''sj6webdb'' のバックアップ情報が見つかりません。', 16, 1) end
RESTORE VERIFYONLY FROM  DISK = N'D:\fes\SQLBackup\sj6webdb\sj6webdb.bak' WITH  FILE = @backupSetId,  NOUNLOAD,  NOREWIND
GO

BACKUP LOG [sj6webdb] WITH TRUNCATE_ONLY
GO