1 2 3 4 5 6 7 8
|
BACKUP DATABASE [Mabase] TO DISK = N'E:\SQL_SERVER_2005\MSSQL.1\MSSQL\Backup\Mabase.bak' WITH DESCRIPTION = N'Sauvegarde compl_te Mabase', RETAINDAYS = 1, NOFORMAT, INIT, NAME = N'Mabase.bak', SKIP, NOREWIND, NOUNLOAD, STATS = 10, CHECKSUM
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N'Mabase' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N'Mabase' )
if @backupSetId is null begin raiserror(N'Échec de la vérification. Les informations de sauvegarde pour la base de données «*Mabase*» sont introuvables.', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N'E:\SQL_SERVER_2005\MSSQL.1\MSSQL\Backup\Mabase.bak' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO |
Partager