DBCC SHRINKFILE

[latitude800]

I am trying to skrink the log files for a database logical name GPSDYNAMICSLog.ldf, I want to have 2 MB size, and I do the following.

When I use DBCC SHRINKFILE (GPSDYNAMICSLog, 2) I get the following:
Server: Msg 8985, Level 16, State 1, Line 1
Could not locate file 'GPSDYNAMICSLog' in sysfiles.

I logical file name in the sysfiles is GPSDYNAMICSLog.ldf

Any suggestions? Appreciate your assitance in advance

Thanks
James

 

[mrdenny]

GPSDYNAMICSLog.ldf is the physical name, not the logical name.

Check the sysfiles table and make sure you have the correct logical name.

Also make sure that you are executing this command within the correct database.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com