Q: My application generates log files rapidly - how do i truncate the size of the log in SQL server without affecting the data files. this will help me to space in the hard disk

SQL Stan says: If the application is not mission critical, then run the database in SIMPLE recovery mode. This will automatically truncate the log every minute or so. If the application is critical and you need to be able to recover from a disaster, then use BACKUP to clear the log at regular intervals, say every 15 or 30 minutes.

Technorati Tags:
database recovery, disaster planning, archive log

Add to: | Technorati | Digg | del.icio.us | Yahoo | reddit |