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.
[解决办法]
怎么能越收缩越大？
