August 21, 2009 at 10:36 am
I have an extra log file, how can I remove it? When I try to remove, I get an error message:
That file is not empty and can't be removed.
August 21, 2009 at 11:13 am
Is this a SQL Error log? The SQL log? Or a database transaction log?
What did you try - and what was the exact error message?
If you are talking about a transaction log, lookup the command DBCC SHRINKFILE and pay attention to the EMPTYFILE option. If you can't figure it out from the help, post back with what you have tried and what doesn't work and we will help you out.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 21, 2009 at 12:13 pm
It is located in when I go to the db property under Files. I see: Log file that I don't need, when I click remove,I get an error message, that Log file can't be remove it is not empty
August 21, 2009 at 12:16 pm
You can use the shrink file option to empty the data from the file into another file. Then you'll be able to get rid of it.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 21, 2009 at 12:28 pm
Krasavita (8/21/2009)
It is located in when I go to the db property under Files. I see: Log file that I don't need, when I click remove,I get an error message, that Log file can't be remove it is not empty
I'm sorry - did you forget to look in help and review the topic on DBCC SHRINKFILE like I said? It was a very simple request, and if you do a little research and work yourself - you never know, you might just learn something that will help you on your next issue.
And no - I will not give you the commands since they are very well documented in Books Online (SQL Server help system) and will most likely already have code examples that you can copy/paste and modify as needed.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply