Irma Martis (6/22/2005)

---

We run via the Enterprise Manager (sql server 2000) a Shrinkdatabase job via the SQL Server Agentwith the following statements:

DBCC Shrinkdatabase (xxx, 20)

DBCC Shrinkdatabase (tempdb, 10)

The last couple of days I frequently got the following failed-message:

Executed as user: xxx. Could not adjust the space allocation for file 'xxx'.

[SQLSTATE 42000] (Error 3140) DBCC execution completed. If DBCC printed error messages, contact your system administrator.

[SQLSTATE 01000] (Error 2528) Associated statement is not prepared [SQLSTATE HY007]

(Error 0) Cannot shrink log file 2 (templog) because requested size (7256KB)

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.

(Message 0). The step failed.

Can someone explain to me what's the problem we currently have?