Hi,
The transaction log on our dev database is huge (1.5gig), it doesn't really
need to be that big because its a dev database. How can I reduce the size of
this file? Thanks
amit

Hi Amit,

You can use DBCC SHRINKFILE to shrink the size of the log.

An example in this article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;272318

In addition, you need to take note of the recovery model of the
database. If the database is set to full recovery, be sure to take
transaction log backup to prevent the log from growing too large.


Yih-Yoon Lee
My blog http://www.mssql-tools.com/blog
E-mail: yihyoon.online@gmail.com
/* remove .online to send me e-mail */

[quoted text, click to view]