 |
 |
Database Transaction Log is Full
When you're tring to do something with your big database and you've found error like "..transaction log is full..". Try this command in Query Analyzer :
|
DBCC SHRINKDATABASE(DatabaseName, 10)
|
Replace the DatabaseName with your database name and run it. Wait a minute and then your database will available again.
Please tell me if it can help you :)
|
 |