Droping Transaction Log File

Question

Droping Transaction Log File

rome

Valued Member

Points: 72
More actions
January 14, 2004 at 1:32 pm

#107698

can anyone help me on how to drop a transaction log file from the database?
I have 2 transaction log files. One on C Drive and one on D drive. I want to delete the one on C drive.
Recovery model is full
Please list the steps.
Thanx
October 1, 2021 at 5:30 am

This was removed by the editor as SPAM

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 1

First to empty one of your log file by running "dbcc shrinkfile(logfile_logicalname, emptyfile). Once the file is empty, run "alter database remove file logfile_logicalname)

rome Valued Member Points: 72 More actions · Answer 2

Thanks Allen for your input.

Do I have to take backup of Transaction Log to truncate the log before I empty it. Please comment.

thanks

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 3

It is no necessary.

EMPTYFILE option migrates all data from the specified file to other files in the same filegroup.

mssql_rules SSCrazy Points: 2783 More actions · Answer 4

I thought you would not be able to drop the 'primary data or log' file. You can drop the subsequent log files.

rome Valued Member Points: 72 More actions · Answer 5

Thanks guys,

It worked fine. I emptied the file as suggested by Allen, and removed the file from the database.

My database is working fine without the discarded file.

thanks once again all of u