ScottPletcher (1/10/2012)

---

Given that this is SQL 2008 (or SQL 2005 at least), you mean:

SELECT *
FROM test.sys.database_files

right?

To be safe, you really should run against test.sys.database_files

what is the recovery model of your database?

I would not expect it to give the error you see, but anyway the truncateonly option has no effect when applied to a log shrink

I would not expect it to give the error you see, but anyway the truncateonly option has no effect when applied to a log shrink

I have used this script on other servers and been able to free up log space, what should be used?

jpomfret7 (1/10/2012)

---

The file name and info matches in sys.database_files, sys.master_files, sys.sysaltfiles and dbo.sysfiles...


We are in simple recovery and I ran a checkpoint before attempting to shrink the logs


I have used this script on other servers and been able to free up log space, what should be used?

It's a puzzle, thanks for all your help so far :)

USE test
DBCC SHRINKFILE(2,20)

USE test
DBCC SHRINKFILE(2,20)
Since we already know that the fileid is 2, go ahead and try this.