clearing transaction log after ehpi

[Former Member]

hello every body

i want to clear my transaction log on mssql server 2005,

b'se after EHP4 upgrade it was reached near to 96 Gb

i trried this

a. Detach the database

b. Rename the log file

c. Attach the database without the log file

d. Delete the log file

but database was not attaching , it says that the default user was not able to login,

before this i can log in easily with the same user.

now after restart it was not connecting the database with same user error .

b'se of this i am not been able to start the sap system too.

hlp needed

[Former Member · Accepted solution]

First, you need to change the default database of your login, mostly likely the database you detached was default for your login

Please follow this article for instructions: [http://support.microsoft.com/kb/307864]

SAP Note: [4064|https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=806925&nlang=E&smpsrv=https://websmp204.sap-ag.de]

you don't delete the transaction log if you want to clear the transaction log. you use sql command in management studio:

dbcc shrinkfile('logfilename', 1024), where 1024 is desired size in MB to shrink the file.

Now if you have deleted transaction log file from OS, probably you may have to restore the database.

Thanks

Mush

[Former Member · Accepted solution]

thank u it realy helps me