Reduce the size of transaction log

• Ranga N

  SSChasing Mays

  Points: 642

  More actions

  December 30, 2003 at 11:08 am

  #152000

  I restored a production DB into our dev box. The transaction log size is huge, since i will using "Simple" DB recovery model, i want to make the T.log file just 10 MB, it is now 2000MB. How can i do this?

  If i use alter database to change the file size, BOL states that new size must be larger than the current file size

  How can i do this.

  Thanks,

  Ranga

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736494

  More actions

  December 31, 2003 at 10:20 am

  #488384

  Was this the original size? If not a DBCC SHRINKFILE will bring it down or use this script:http://www.sqlservercentral.com/scripts/contributions/26.asp

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones

  The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

  http://www.dkranch.net