日期:2014-05-18  浏览次数:20534 次

DBCC SHRINKFILE 的一个问题
USE   MyData
GO
BACKUP   LOG   MyData   WITH   NO_LOG
GO
CHECKPOINT
GO
DBCC   SHRINKFILE   (2,   1024)

Error   Message:
Cannot   shrink   log   file   2   (MyData_Log1)   because   requested   size   (1048576KB)   is   larger   than   the   start   of   the   last   logical   log   file.
DbId FileId CurrentSize MinimumSize UsedPages EstimatedPages
11 2 139264 16377 139264 16376

(1   row(s)   affected)

DBCC   execution   completed.   If   DBCC   printed   error   messages,   contact   your   system   administrator.

------解决方案--------------------
because requested size (1048576KB) is larger than the start of the last logical log file.

------解决方案--------------------
怎么能越收缩越大?