-
Hi
I tried
CHECKPOINT
DBCC SHRINKFILE(Invoice_Log)
----
Cannot shrink log file 2 (Invoice_Log) because all logical log files are in use.
DbId FileId CurrentSize MinimumSize UsedPages EstimatedPages
------ ------ ----------- ----------- ----------- --------------
8 2 142544 3185 142544 3184
---
dbcc sqlref shows
Database Name = 'Invoice'; Log Size ( MB) = 1113.6172 ; Log Space Used (%) = 7.017683 ; Status = 0;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|