Sql server 2008 日志满对应的收缩日志的sql

星期日, 2010-03-21 | Author: Lee | Database, JAVA-and-J2EE | 3,501 views

sql如下:
BACKUP LOG dbname to disk=’dbname.log’
DBCC SHRINKFILE (‘dbname_log’,1)

不过要记得执行两遍才可以最终执行收缩;

Tags: , , ,

文章作者: Lee

本文地址: https://www.pomelolee.com/567.html

除非注明,Pomelo Lee文章均为原创,转载请以链接形式标明本文地址

No comments yet.

Leave a comment

Search

文章分类

Meta