程序实现清除Sql数据库日志 ( 积分: 100 )

程序实现清除Sql数据库日志

FADOQuery.Close;
FADOQuery.SQL.Clear;
FADOQuery.SQL.Add
('exec sp_dboption ''' + DBName +
''', ''trunc. log on chkpt.'', ''True''')
FADOQuery.Close;
FADOQuery.SQL.Clear;
FADOQuery.SQL.Add
('BACKUP LOG ' + DBName +
' WITH TRUNCATE_ONLY DBCC SHRINKFILE (' + FLdfName + ', 10)');

接受答案了.