Резервное копирование 1С средствами MS SQL.

RESTORE LOG mydb
    FROM DISK = N'C:\Backup\log2.trn'
    WITH STOPAT = '12.02.2013 21:45:00';

GO
BACKUP DATABASE [82PMOVK_AK] TO  DISK = N''F:\_arhive\82PMOVK_AK\82PMOVK_AK_backup_2015_10_21_105824_7325670.diff'' WITH  DIFFERENTIAL , NOFORMAT, NOINIT,  NAME = N''82PMOVK_AK_backup_2015_10_21_105824_7325670'', SKIP, REWIND, NOUNLOAD,  STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''82PMOVK_AK'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''82PMOVK_AK'' )
if @backupSetId is null begin raiserror(N''Ошибка верификации. Сведения о резервном копировании для базы данных "82PMOVK_AK" не найдены.'', 16, 1) end
RESTORE VERIFYONLY FROM  DISK = N''F:\_arhive\82PMOVK_AK\82PMOVK_AK_backup_2015_10_21_105824_7325­670.diff'' WITH  FILE = @backupSetId,  NOUNLOAD,  NOREWIND

2015-11-14 21:00:27.11             Database backed up. Database: 83BP_NN_TRIM, creation date(time): 2015/02/10(12:34:50), pages dumped: 90401, first LSN: 756:4676:37, last LSN: 756:4692:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{101F414D-13B6-4E75-9E34-9A17172239BB}19'}). This is an informational message only. No user action is required.

DECLARE *path varchar(1000)

SET *path = 'e:\mssql7\BACKUP\FER02_Data_db_' +

    CAST(YEAR(getdate()) as varchar) +

    RIGHT('0' + cast(MONTH(getdate()) as varchar), 2)+

    RIGHT('0' + cast(DAY(getdate()) as varchar), 2)+

    RIGHT('0' + cast(datepart(hour, getdate()) as varchar), 2) +

    RIGHT('0' + cast(datepart(minute, getdate()) as varchar), 2) +

    '.BAK'

--print *path


BACKUP DATABASE [FER02_Data] TO DISK = *path

WITH

    NOINIT ,

    NOUNLOAD ,

    NAME = 'FER02_Data backup',

    SKIP ,

    STATS = 10,

    NOFORMAT

declare *path varchar(200)
set *path=N'E:\backup\LABAM\labam_' + RIGHT(cast(day(GETDATE()) as varchar), 1) + '.bak'
select *path
BACKUP
DATABASE [LABAM] TO DISK = *path
WITH FORMAT, INIT, NAME = N'LABAM',
STATS=1, CHECKSUM
GO