SQL Server Performance Forum – Threads Archive
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
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
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