Need to get rid of large log files. The database is read only.

• dryg7

  SSC Veteran

  Points: 218

  More actions

  February 4, 2010 at 9:49 pm

  #215381

  Hi guys,

  I have a question.

  I have a customer database. I restored it on my SQL Server 2005. After I restored the backup file I have got one mdf file 35GB and two ldf files 32GB each. I would like to get rid of big log files.

  I have tried to detach the database, rename the log files and to attach the database with no log files in hope that it will create a new small log file. This did not work. It does not attach the database without original big log files.

  Then I was trying to truncate log files and did not work again.

  What else I can do in order to get rid of two big log files and replace it with one small one.

  Thanks in advance.

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  February 5, 2010 at 1:58 am

  #1114245

  Check the recovery model for the database. Is it simple or full?

  Set it to simple, then shrink the log files.

  -- Gianluca Sartori

• SQLBOT

  SSCrazy Eights

  Points: 8014

  More actions

  February 8, 2010 at 6:49 am

  #1115440

  You shrink the files with DBCC Shrinkfile

  http://msdn.microsoft.com/en-us/library/ms189493%28SQL.90%29.aspx

  Craig Outcalt

  ---

  
  Tips for new DBAs: http://www.sqlservercentral.com/articles/Career/64632
  My other articles: http://www.sqlservercentral.com/Authors/Articles/Craig_Outcalt/560258