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.
------解决方案--------------------
怎么能越收缩越大？