SQL Server Performance Forum – Threads Archive

using shrinkfile

hello,
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
J

Confirm the real names of log files. Luis Martin
Moderator
SQL-Server-Performance.com 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
J

]]>