摘要:
use [master] -----------修改master为你的数据库DECLARE @dbname VARCHAR(60)SELECT @dbname = CONVERT(VARCHAR(60), DB_NAME())exec('DUMP TRANSACTION ['+@dbname+'] WITH NO_LOG') DECLARE @logname VARCHAR(60) SELECT @logname = rtrim(ltrim(name)) FROM sysfiles WHERE name LIKE '%log%' exec( 阅读全文
posted @ 2011-07-26 20:03
qanholas
阅读(224)
评论(0)
推荐(0)