InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 03:57:36 GMT20http://www.sqlservercentral.com/Forums/Topic1370267-1550-1.aspxUse the following command:SELECT file_id,name ,size/128.0 - CAST(FILEPROPERTY(name, 'SpaceUsed') AS int)/128.0 AS AvailableSpaceInMBFROM sys.database_files;after this command u will find the file id which has free space then run DBCC shrinkfile(file id)Wed, 10 Oct 2012 03:18:56 GMTmahesh.dasonihttp://www.sqlservercentral.com/Forums/Topic1370267-1550-1.aspxMy guess is, you would be using wrong file nameWed, 10 Oct 2012 02:26:30 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1370267-1550-1.aspxHi AllI had a weird situation this morningOn one of my test systems, I tried running the following command to shrink my log file [code="sql"]DBCC shrinkfile(filename,1024)[/code]I received this error[i]Could not locate file 'filename' for database 'database_name' in sys.database_files. The file either does not exist, or was dropped. [/i]I checked and the file does exist.I ran a full Consistency Check (DBCC CHECKDB) and that seems to have fixed the problem.Has anyone else come across this before? Should I be worried?ThanksTue, 09 Oct 2012 03:46:45 GMTSQLSACT