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

 BACKUP DATABASE [budget] TO DISK = N'd:\backup\budget.bak' WITH  INIT,  NOUNLOAD,  NAME = N'budget backup',  NOSKIP,  STATS = 10, NOFORMAT
 BACKUP LOG  [budget]  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\*.*

Уменьшение размера log файла в SQL Server 2008

 USE budget;
 ALTER DATABASE budget SET RECOVERY SIMPLE;
 DBCC SHRINKFILE(budget_log, 0);
 ALTER DATABASE budget SET RECOVERY FULL;

Контроль соединений

select program_name,net_transport
from sys.dm_exec_sessions as t1
left join sys.dm_exec_connections AS t2 ON t1.session_id=t2.session_id
where not t1.program_name is null