Hi Patrick, You can do it like this, or you can manually look up the fileid by just doing a "select * from sysfiles" declare @fileid int select @fileid = fileid from sysfiles where name = 'YOUR-DASHED-FILENAME_LOG' dbcc shrinkfile (@fileid) Note that the name of the file is typically the physical filename without the .ldf extension. Maybe it's best just to first do "select * from sysfiles" and then run dbcc shrinkfile (theIDyouGetFromSysfilesTableManually) From: windows2000-bounce@xxxxxxxxxxxxx [mailto:windows2000-bounce@xxxxxxxxxxxxx] On Behalf Of Patrick Sent: Wednesday, December 05, 2007 8:25 AM To: windows2000@xxxxxxxxxxxxx Subject: [windows2000] Re: Sql 2000 question we were running the shrinkfile command and it kept throwing up errors with the file name. I have seen it somewhere that - not _ are not allowed within the file name. We ran same command on other files without the - and it worked. Not quite sure how we can run the command on ID rather than filename still quite new to Sql. Thanks ----- Original Message ---- From: Ray Costanzo <ray@xxxxxxxxxx> To: windows2000@xxxxxxxxxxxxx Sent: Wednesday, December 5, 2007 12:52:15 PM Subject: [windows2000] Re: Sql 2000 question What is the problem that you are having? That is, why command are you executing, what results are you expecting, and what results are you getting? I don?t recall having problems with dashes in file names, but I can?t specifically remember an instance where I had a dash either. Have you tried shrinking the file by ID instead of by name? From: windows2000-bounce@xxxxxxxxxxxxx [mailto:windows2000-bounce@xxxxxxxxxxxxx] On Behalf Of Patrick Sent: Wednesday, December 05, 2007 7:32 AM To: windows2000@xxxxxxxxxxxxx Subject: [windows2000] Sql 2000 question Hi Guys, Not quite sure if I would find the answer here, but I will ask anyway. We have an SQL server 2000, with a DB Fire-fly2000.mdb (350mb), and a corresponding logfile Fire-fly2000.ldf (69GB). Now the issue is that we want to shink the .ldf file cos of disk space, but we are having a problem with the naming convention. SQL does not like - in names. Is there a way we can get around this? Thanks _____ Never miss a thing. Make Yahoo your homepage. <http://us.rd.yahoo.com/evt=51438/*http:/www.yahoo.com/r/hs> _____ Looking for last minute shopping deals? Find <http://us.rd.yahoo.com/evt=51734/*http:/tools.search.yahoo.com/newsearch/ca tegory.php?category=shopping> them fast with Yahoo! Search.