Article ID: 260
Last updated: 17 May, 2011
SQL Log: It records recent database transactions and is used to ensure database integrity in the event of a system restore, like database queries, updating/insertion/deletion of the records and all other database action. You can say it is a temporary location for database actions and data. Then it finally commits the changes to the database. For a busy database it’s necessary to truncate the database log frequently to clear the disk space. The SQL log file can grow very large and consume all existing allowed space. You can truncate the SQL log file remotely without admin privileges,
USE your_db_name_here You are done!
This article was:
Report an issue
Article ID: 260
Last updated: 17 May, 2011
Revision: 4
Views: 43514
Comments: 0
|