How to remove 2 ldf file from MS SQL Server 2008 in SAP

[Former Member]

Hi Team,

I done some activity

i.e.  Login into SQL Management Console --: detach database

Renaming log file then again attach database then new log file created and I can delete renamed log

but this is applicable for where only one log file in database

But here is scanario is I hv 2 ldf log file and I did same thing as mention above

This time it's giving error attach database depend one or more file

Cannot attached

Please help to resolve

Regards,

Santosh

[Former Member · Accepted solution]

Dear All,

Issue was resolved from myself

Actually I go to Database proeprties option set backup recovery mode is normal then shrink the database till from 125 gb to 1gb or also check to rename database after detach when I again attach automatically ldf file created and then

Again go to database and set recovery mode is full

Thanks for support

[Sriram2009]

Hi Santosh.

Could you refer the Microsoft link, Before start this process take the full backup of your DB & Stop the SAP instance.

https://msdn.microsoft.com/en-us/library/ms345483.aspx

Regards

SS

[former_member184473]

Hello Santosh,

You cannot delete logfiles after the detach otherwise you will not be able to attach the database.
You must restore you database from a good backup.

To remove a logfile, check note 363018:

C. Adding and removing database files

d) Removing log files

Regards,
Eduardo Rezende
SAP Support