读书人

DBCC SHRINKFILE 的一个有关问题

发布时间: 2012-02-19 19:43:39 作者: rapoo

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.
DbIdFileIdCurrentSizeMinimumSizeUsedPagesEstimatedPages
1121392641637713926416376

(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.

[解决办法]
怎么能越收缩越大?

读书人网 >SQL Server

热点推荐