SQLServer收缩日志及数据库文件
收缩数据库文件：DBCC SHRINKDATABASE(@dbName )
DUMP TRANSACTION @dbName WITH NO_LOG
--截断事务日志：
BACKUP LOG @dbName WITH NO_LOG
--收缩日志文件：
DBCC SHRINKFILE
(
{ 'file_name' | file_id }
{ [ , EMPTYFILE ]
| [ [ , target_size ] [ , { NOTRUNCATE | TRUNCATEONLY } ] ]
}
)
[ WITH NO_INFOMSGS ]
页:
[1]