Hi,

Increasing the size of the log file of a SQL server DB is a big issue for me.

a) Can I Instruct to SQL server to stop writing to log file? If so how?

b) Can I instruct SQL server to delete the log file and create a fresh log file automatically on daily basis? If so how?

c) Or does any body have an another solution for my issue? If so what is it?

Thanks in advance

a) you can change the recovery mode of your database to simple. ( I think it is full now ) BUT IT IS NOT ADVISABLE TO CHANGE THIS. In case of a data recovery you will not be able to recover if you have a simple recovery method.

b) yes you can.

Deatatch Db

Delete Log

Attach Mdf file .

( I have bad expereces on this when there are multiple log files in database)

Also , you can have Backup NO LOG

BACKUP LOG AdventureWorks WITH NO_LOG;
This is absolutely not recommended because it breaks the log chain, the series of log backups from which you would recover your database to a point in time. Microsoft recommends running a full backup immediately after using this statement.

c) Put this command in job and schedule it

This may be dealyed answer. Sorry about it

Log file is usefull for data recovery. After taking a Full backup, you can truncate log by BACKUP NO LOG command. But make sure that you do this after taking a full backup for safety reasons.

 Apart from this, check your recovery method. If you changed your recovery method to simple u won't get huge log file. BUT This ot advisable as you may lost ability to recover your data when needed.