Solved

Can not Shrink Log File.  I am getting The file either does not exist, or was dropped.

Posted on 2008-10-14
11
2,676 Views
Last Modified: 2012-05-05
I am trying to shrink a Log File but ever time I run DBCC SHRINKFILE i get this error.

"Could not locate file 'GPSOPERALog' for database 'PLAY' in sys.database_files. The file either does not exist, or was dropped. "

I have ran sp_helpfile to confirm the logical name of the file and everything is correct.  I have also check the properties to make sure of the location of the file and it is there.  I have even tried to move the file but I get an error telling me the file is in use.

I did notice that I there are two databases on this server that have different log file names but the Logical name for both log files are the same.

What do I need to do to shrink this file.  Here is how I have the code written to do this.

DBCC SHRINKFILE(GPSTWOLog, 100)

Thanks,

Gabicusc

0
Comment
Question by:GabicusC
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
11 Comments
 
LVL 60

Expert Comment

by:chapmandew
ID: 22714022
have you ran this?

restore filelistonly from disk = 'c:\backup.bak'

the name field will give you the name of your log file.
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 22714028
whoa....that last comment was totally off..

try this:

select * from sys.database_files
0
 

Author Comment

by:GabicusC
ID: 22714670
I ran the select statement and this is what I get.



database-files-results.xls
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
LVL 60

Expert Comment

by:chapmandew
ID: 22714698
OK, try this then:

DBCC SHRINKFILE(GPSOPERALog, 100)
0
 

Author Comment

by:GabicusC
ID: 22714753
chapmandew,

Thanks.  That is what I have been trying and I am still getting the same error.  I can not figure out why it does not see the file.

Gabicus
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 22714770
are you running it in the correct database?
0
 

Author Comment

by:GabicusC
ID: 22714810
Yes.  I wish it was that easy.  I have just for kicks tried and run it on the other databases on the server.  The issue that I am having is that my C drive has 0 space on it right now.  The last time the trans file was written to was back in August.  I am wondering if that could be the issue.  But I can not even touch this file and try and move it.
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 22714868
I would say that is definetly an issue.  Are there any old backups on that drive that you can move off or delete?
0
 

Author Comment

by:GabicusC
ID: 22715024
no.  I am not finding any old Back ups that I can move to free up some room. I believe that this Data base is a test Database.   Not sure.  If it is. I am thinking the best way to do this is to detach the database then move the log file and re-attach the database and rename the logical name for the log files.

Do you think that there might be an easier way to do this?
0
 
LVL 60

Accepted Solution

by:
chapmandew earned 500 total points
ID: 22715089
No....I was just getting ready to suggest you detach and reattach it elsewhere...I think it is your best option at this point.
0
 

Author Comment

by:GabicusC
ID: 22715367
chapmandew,


Thanks for all your help,  we are working on it right now.

Gabicus
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question