On hosting server often exists database quota for MS SQL Server. Even if your database contains small amount of data, but there is goes intensive adding/modifacation of the data, in some point the size of the data could exceed quota and your account may be suspended.
This happens because of growth of the transaction log.
To clear transaction log you can execute the following command:
Showing posts with label transaction log. Show all posts
Showing posts with label transaction log. Show all posts
Tuesday, January 6, 2009
Subscribe to:
Posts (Atom)