on 12-16-2009 10:53 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.