none
Cannot shrink log file 2 because the logical log file located at the end of the file is in use ?

    Question

  • HI,

    I am getting this error frequently.. any recomendations :

     

    Executed as user: DB0\sqlservices. Processing database: dbin [SQLSTATE 01000] (Message 0)  Cannot shrink log file 2 (DB_log) because the logical log file located at the end of the file is in use. [SQLSTATE 01000] (Message 9008)  Processing database: DB_ [SQLSTATE 01000] (Message 0)  DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528)  Cannot shrink log file 2 (DB_log) because the logical log file located at the end of the file is in use. [SQLSTATE 01000] (Message 9008)  Processing database: DB [SQLSTATE 01000] (Message 0)  DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528)  Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed. [SQLSTATE 42000] (Error 3023)  Processing database: DB_AC [SQLSTATE 01000] (Error 0)   [SQLSTATE 01000] (Error 0)  DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Error 2528).  The step failed.

     

    Please give any receomendations to avoid this error in future :


    Yangamuni Prasad M
    Tuesday, March 22, 2011 6:00 AM

Answers

All replies