摘要：
DECLARE @sql VARCHAR(max)DECLARE @name VARCHAR(max)DECLARE @path VARCHAR(max)DECLARE @i VARCHAR(max)SET @i=1WHILE (@i<=48)BEGIN SET @name='tempdev'+CAST(@i AS VARCHAR(20))SET @path='F:\tempdb\'+@name+'.ldf'SET @sql='USE [master]ALTER DATABASE [tempdb] ADD FILE ( NAME = 阅读全文
摘要：
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( 阅读全文
