Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SQL Server Agent Error

Author  Topic 

opowell
Starting Member

12 Posts

Posted - 2009-06-08 : 10:50:04
Pulled this from the log history.
Date 6/6/2009 1:01:00 AM
Log Job History (DBNAME_DefragIndexes)

Step ID 1
Server Server name
Job Name DBNAME_DefragIndexes
Step Name DefragIndexes
Duration 00:11:10
Sql Severity 17
Sql Message ID 2549
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: domain\dbadmin. DBCC execution completed. If DBCC printed error messages, contact your system administrator.
[SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528) The log file for database 'DBNAME' is full. Back up the transaction log for the database to free up some log space. [SQLSTATE 42000] (Error 9002) The log file for database 'DBNAME' is full. Back up the transaction log for the database to free up some log space. [SQLSTATE 42000] (Error 9002) DBCC: Defrag phase of index 'DBNAME.dbo.DEBIT_BALANCES' is 31% complete. [SQLSTATE 01000] (Error 2549) DBCC: Defrag phase of index 'DBNAME.dbo.DEBIT_BALANCES' is 66% complete. [SQLSTATE 01000] (Error 2549). The step failed.

The most
   

- Advertisement -