Trim Your SQL DBs Log Remotely

Last Updated on Saturday, 16 February 2013 11:36 Written by Naveed Ashraf Saturday, 16 February 2013 12:00

The SQL Log records transaction made into database. These log-entries can be used later to check the actions with database. It also used to ensure database integrity in the event of a system restore, includes but not limited to database queries, updating/insertion/deletion of the records. They are just like a temporary location where SQL Server engine temporary store transactions and at final commits the transaction to the database. To clear the disk space and clean the database log, we need to truncate/trim the database log frequently specially for a very active database. Many times the SQL log file grow very large and consume too much space over server. This might also cause to slow performance of a busy database. Here are steps to trim the SQL log remotely.
Learn More

Search

Authors

Web Hosting

Linux Hosting
ASP .NET Hosting
Business Hosting
Reseller Hosting
E-Commerce Hosting
Dedicated Servers

Acceptable Use Policy
Terms of Service
Privacy Policy

Affiliate Program
Site Map

Blog Hosting

PostNuke Hosting
WordPress Hosting
b2evolution Hosting
Textpattern Hosting
Habari Hosting


CMS Hosting

CMS Made Simple Hosting
phpNuke Hosting
Geeklog Hosting
phpWCMS Hosting
phpWebSite Hosting
Shopping Cart Hosting

OpenCart Hosting
osCommerce Hosting
CubeCart Hosting
Buy Safe Hosting
Zen Cart Hosting


Video Sharing Software Hosting

iVidPlay Hosting
ClipBucket Hosting
ClipShare Hosting
osTube Hosting
vShare Hosting
Forum Hosting

XMB eXtreme Hosting
phpBB Hosting
Simple Machines Hosting
Vanilla Forum Hosting
AEF Hosting


Social Network and Community Website Hosting

SocialEngine Hosting
Jcow Hosting
Skadate Hosting
Dolphin Hosting
Elgg Hosting
Copyright © 2003-2013 Arvixe, LLC. All trademarks are property of their legal owner.