DBCC Error

• Bidec

  SSCommitted

  Points: 1666

  More actions

  December 8, 2003 at 6:55 am

  #76091

  Hi All,

  I run this DBCC script on my database once a week.

  dbcc shrinkdatabase ([dbname],10)

  Last time it ran I got this error message :

  Executed as user: RJRWS\USERNAME. ...---- [SQLSTATE 01000] (Message 0) Cannot shrink log file 2 (DB_Log) because requested size (56768KB) is larger than the start of the last logical log file. [SQLSTATE 01000] (Message 9007) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528)

  Any Idea what could have happened ?

  Thanks.

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  December 8, 2003 at 7:26 am

  #485077

  Try to backup/truncate the database log and shrink it again.