DBCC shrinkfile gives error

sql-server transaction-log dbcc
user70636 picture user70636 · Mar 9, 2010 · Viewed 11.6k times · Source

I am trying to shrink my log file using DBCC SHRINKFILE(db_2.ldf), which is the name for log file

It gives me error every time:

8985, Level 16, State 1, Line 1 Could not locate file 'FIelD' for database db in sys.database_files. The file either does not exist, or was dropped.

Can you please suggest what can I do to fix it.

Answer

onupdatecascade picture onupdatecascade · Mar 9, 2010

The file name should be the logical file name and not the physical file name. Look in the Database properties, on the Files tab for the Logical Name of the file you are trying to shrink, and use that name.

Related questions

DBCC SHRINKFILE on log file not reducing size even after BACKUP LOG TO DISK

I've got a database, [My DB], that has the following info: SQL Server 2008 MDF size: 30 GB LDF size: 67 GB I wanted to shrink the log file as much as possible and so I started my quest to figure out how …

Read More
How do you clear the SQL Server transaction log?

I'm not a SQL expert, and I'm reminded of the fact every time I need to do something beyond the basics. I have a test database that is not large in size, but the transaction log definitely is. How do …

Read More
How to view transaction logs in SQL Server 2008

I need to view the transaction logs of a database on SQL Server 2008 in order to find a delete transaction and hopefully roll it back. Unfortunately I have no clue where to start, and I'm finding it difficult to determine …

Read More