shrink report server_log file in sql server 2008

• viswanath09

  Mr or Mrs. 500

  Points: 512

  More actions

  January 16, 2011 at 11:48 pm

  #232962

  HI all.

  i need to shrink report server_log file in sql server 2008. please let me know the details.

• psingla

  Hall of Fame

  Points: 3840

  More actions

  January 17, 2011 at 5:05 am

  #1274193

  have you tried

  dbcc shrinkfile(<'logfilename'>)

  works better in simple recovery mode

  Pramod
  SQL Server DBA | MCSE SQL Server 2012/2014
  in.linkedin.com/in/pramodsingla/
  http://pramodsingla.wordpress.com/