using shrinkfile | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

using shrinkfile

I am trying to shink the log file of a db; the backup job failed and it has gotten too large. This is the command and error message I am getting. When I look in sysfiles in master, there are only two entries, is there a way to rebuild this file? Is it necessary? dbcc shrinkfile (db_log, 100) Server: Msg 8985, Level 16, State 1, Line 1
Could not locate file ‘db_log’ in sysfiles.
DBCC execution completed. If DBCC printed error messages, contact your system administrator. thanks
Confirm the real names of log files. Luis Martin
Moderator One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
Ahh, son of a dog. I was using the physical file name, I hadn’t used sp_helpdb on the DB. brain cramp. thanks