Friday, March 9, 2012

Error in Maintenance Plan (tempdb)

Hello
Give this error in Maintenance Plan:
8] Database openview: Removing unused space from the database files (if
database size is more than 50 MB). Reducing free space to 10 percent of
data...[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 9002:
[Microsoft][ODBC SQL Server Driver][SQL Server]The log file for
database
'tempdb' is full. Back up the transaction log for the database to free up
some log space.
End of maintenance plan 'DB Maintenance Plan openview' on 13-07-2006 0:00:22
SQLMAINT.EXE Process Exit Code: 1 (Failed)
What should I do?
Regards
José Júlio DuarteYou need to clear the tempdb, There are few methods by which you can do
this
http://support.microsoft.com/defaul...kb;en-us;307487
"Jos Jlio Duarte" <JosJlioDuarte@.discussions.microsoft.com> wrote in
message news:59EC2548-AAB9-4456-9001-B326BC9756D4@.microsoft.com...
> Hello
> Give this error in Maintenance Plan:
> 8] Database openview: Removing unused space from the database files (if
> database size is more than 50 MB). Reducing free space to 10 percent of
> data...[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 9002:
> [Microsoft][ODBC SQL Server Driver][SQL Server]The log file fo
r database
> 'tempdb' is full. Back up the transaction log for the database to free up
> some log space.
> End of maintenance plan 'DB Maintenance Plan openview' on 13-07-2006
0:00:22
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
>
> What should I do?
> Regards
> Jos Jlio Duarte

No comments:

Post a Comment