Play Flash Games


© 2007 Red Computer

HTML Howto, CSS Howto, JavaScript Howto, PHP Howto, Windows Howto
Google

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 :)



Visitor's Comment

Post a Comment
Comment
Name :
E-mail :

HOME | HTML | CSS | JavaScript | PHP | XML | SQL | Virus Fix | Windows | Downloads | Links