Serg0FFan
Silver Member | Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору
EXECUTE master.dbo.xp_create_subdir N'S:\!copy!\SQLBack\work_firma_texno'
GO
EXECUTE master.dbo.xp_create_subdir N'S:\!copy!\SQLBack\work_pk_texno'
GO
EXECUTE master.dbo.xp_create_subdir N'S:\!copy!\SQLBack\zup_ooo_texno'
GO
EXECUTE master.dbo.xp_create_subdir N'S:\!copy!\SQLBack\work_bux_majorova'
GO
BACKUP DATABASE [work_firma_texno] TO DISK = N'S:\!copy!\SQLBack\work_firma_texno\work_firma_texno_backup_200912150949.bak' WITH DIFFERENTIAL , NOFORMAT, NOINIT, NAME = N'work_firma_texno_backup_20091215094940', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N'work_firma_texno' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N'work_firma_texno' )
if @backupSetId is null begin raiserror(N'Ошибка верификации. Сведения о резервном копировании для базы данных "work_firma_texno" не найдены.', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N'S:\!copy!\SQLBack\work_firma_texno\work_firma_texno_backup_200912150949.bak' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO
BACKUP DATABASE [work_pk_texno] TO DISK = N'S:\!copy!\SQLBack\work_pk_texno\work_pk_texno_backup_200912150949.bak' WITH DIFFERENTIAL , NOFORMAT, NOINIT, NAME = N'work_pk_texno_backup_20091215094940', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N'work_pk_texno' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N'work_pk_texno' )
if @backupSetId is null begin raiserror(N'Ошибка верификации. Сведения о резервном копировании для базы данных "work_pk_texno" не найдены.', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N'S:\!copy!\SQLBack\work_pk_texno\work_pk_texno_backup_200912150949.bak' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO
BACKUP DATABASE [zup_ooo_texno] TO DISK = N'S:\!copy!\SQLBack\zup_ooo_texno\zup_ooo_texno_backup_200912150949.bak' WITH DIFFERENTIAL , NOFORMAT, NOINIT, NAME = N'zup_ooo_texno_backup_20091215094940', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N'zup_ooo_texno' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N'zup_ooo_texno' )
if @backupSetId is null begin raiserror(N'Ошибка верификации. Сведения о резервном копировании для базы данных "zup_ooo_texno" не найдены.', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N'S:\!copy!\SQLBack\zup_ooo_texno\zup_ooo_texno_backup_200912150949.bak' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO
BACKUP DATABASE [work_bux_majorova] TO DISK = N'S:\!copy!\SQLBack\work_bux_majorova\work_bux_majorova_backup_200912150949.bak' WITH DIFFERENTIAL , NOFORMAT, NOINIT, NAME = N'work_bux_majorova_backup_20091215094940', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N'work_bux_majorova' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N'work_bux_majorova' )
if @backupSetId is null begin raiserror(N'Ошибка верификации. Сведения о резервном копировании для базы данных "work_bux_majorova" не найдены.', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N'S:\!copy!\SQLBack\work_bux_majorova\work_bux_majorova_backup_200912150949.bak' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
|
