Data Base

Discussion in 'Help' started by brotherjcv, Jun 11, 2010.

  1. brotherjcv

    brotherjcv New Member

    DataBase lin2db_log.ldf 120 GB oO Someone help me decrease the size. I have both players to have it all GBs folder, what do I do?
     
    brotherjcv, Jun 11, 2010
    #1
  2. FidoW

    FidoW AdvExt64 Customers (IL)

    Run this one:

    Code:
    DBCC SHRINKDATABASE([lin2db],2)
BACKUP LOG [lin2db] WITH TRUNCATE_ONLY
DBCC SHRINKDATABASE([lin2db],2)
     
    FidoW, Jun 11, 2010
    #2
  3. brotherjcv

    brotherjcv New Member

    thanks. ok ^^
     
    brotherjcv, Jun 11, 2010
    #3