Shrink Database

• Bidec

  SSCommitted

  Points: 1666

  More actions

  February 6, 2004 at 1:59 pm

  #65532

  Hi All,

  I have a job to shrink the database and log files once a month. It was working fine for long time but recently I have started getting this error message for each of the databases :

  Cannot shrink log file 2 (db_Log) because requested size (1152KB) is larger than the start of the last logical log file. [SQLSTATE 01000]

  Please let me know what am I doing wrong.

  Thanks.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736255

  More actions

  February 6, 2004 at 2:42 pm

  #493167

  Try this: http://www.sqlservercentral.com/scripts/contributions/26.asp