I have a database that is mirrored and has a lot of VLFs so I want to shrink and resize the logfile to reduce this. Being a cautious DBA I wasnt sure how the mirroring might affect (or be affected by) this process so I have taken a trivial database on a test server and mirrored it. I am now trying to execute DBCC SHRINKFILE and I'm getting a weird error. USE [AUTOINDEXRECS] GO SELECT name , [df].[type_desc] FROM [sys].[database_files] AS df go DBCC SHRINKFILE (N'AUTOINDEXRECS_log' , 0, TRUNCATEONLY) GO give results of: name type_desc ----------------- ----------- AUTOINDEXRECS ROWS AUTOINDEXRECS_log LOG > (2 row(s) affected) > Msg 8985, Level 16, State 1, Line 1 > Could not locate file `AUTOINDEXRECS_log` for database 'AUTOINDEXRECS' in `sys.database_files`. The file either does not exist, or was dropped.