cancel
Showing results for 
Search instead for 
Did you mean: 

How can I delete transaction log

Former Member
0 Kudos

Hello

How can I delete transaction log. It is an IDES System(windows/SQL2005) and I do not need Transaction log. System started beghaving very slow. I do not know but i guess transaction log is reason(only 922M left)

Thank you in advance

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi

Basically, you can shrunk log file to regain the space.

Please refer to below KB docs of Microsoft for more info (though they are of 2000 but useful for SQL 2005 also)

SQL 2005 oriented

http://support.microsoft.com/default.aspx/kb/873235/

See KB #110139 to understand why the transaction log might fill up.

See KB #317375 for information about full or unexpectedly growing log files.

See KB #873235 for information about preventing unexpected log file growth.

Regards

Sekhar

Edited by: sekhar on Dec 16, 2009 12:11 PM

Answers (0)