|
Blue Forest http://www.lslnet.com at 11:08 on July 8, 2006
DOWN services suggested there! ! !
Indicated : a system is in the idle state of affairs.
Which is how I found affairs?
One task (s) are sleepin waititing for space to become available in the
XXXXX segent for database log. |
Sp_who |
Sp_who or DBArtisan, the database log because it is full of affairs has been waiting for this release log space. |
Upstairs friends, a solution can only be cut off log myself? Is a specific operation? |
Check the last active transaction. (Master. . Syslogshold) |
Dump transaction with truncate_only databasename |
Thank you!
Inquiries to what grammar
Master. . Syslogshold described?
Is a select? |
Samplest way is the select * :) |
Grammar can be shown End all out?
I was a novice |
Select * from master. . Syslogshold |
QQ friends upstairs? Very much like to learn more and you |
| |