Posted on 2010-09-22
Obviously I am not a SQL person...
I have an application that is locking up because the log file (carpedata_log) is full. I opened SQL and ran the following query:
dbcc shrinkfile (carpedata_log,10)
backup log carpedata_log with truncate_only
The response I get is:
Cannot shrink log file 2 (carpedata_log) because all logical log files are in use.
(1 row(s) affected)
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 911, Level 16, State 10, Line 3
Could not locate entry in sysdatabases for database 'carpedata_log'. No entry found with that name. Make sure that the name is entered correctly.
Msg 3013, Level 16, State 1, Line 3
BACKUP LOG is terminating abnormally.
Dbld - 7
Field - 2
CurrentSize - 27392760
MinimumSize - 25600
UsedPages - 27392760
EstimatedPages - 25600