Резервное копирование 1C для MS SQL

Материал из LinTest Wiki

BACKUP DATABASE [budget] TO DISK = N'd:\backup\budget.bak' WITH INIT, NOUNLOAD, NAME = N'budget backup', NOSKIP, STATS = 10, NOFORMAT

BACKUP LOG [budget_log] WITH TRUNCATE_ONLY

USE budget GO DBCC SHRINKFILE (budget_log, TRUNCATEONLY) GO

d:\WinRAR.exe a d:\backup\bud_ -agYYYY-MM-DD_HH-MM d:\backup\budget.bak d:\1SBase\budget\*.*