[SQLSERVER] 把TransactionLog截断
摘要:注意:以下语句非常危险 --BACKUP LOG MyDb TO DISK='NUL:' 顺便压缩文件: Use MyDb DBCC SHRINKFILE (Logical_File_Name, Shrink_To_MB);GO 获取Logical Name的方法: SELECT d.name Da
阅读全文
posted @ 2018-01-23 14:28
posted @ 2018-01-23 14:28
posted @ 2018-01-09 14:49
posted @ 2018-01-09 14:45
posted @ 2018-01-09 14:33