Error 22029

I found this error in Job History, I need help to find out the reason and solution for the following errors.
The job failed. The Job was invoked by Schedule 9 (Schedule 1). The last step to run was step 1 (Step 1).
Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.

This problem i found in Maintenance Plan & error log file:
Maintenance Plan:
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 927: [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'restore_test' cannot be opened. It is in the middle of a restore.
[Microsoft][ODBC SQL Server Driver][SQL

Error Log file:

BACKUP failed to complete the command BACKUP DATABASE [restore_test] TO DISK = N'E:\SQL_Backups\restore_test\restore_test_db_2006 04160200.BAK' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT

Please help me in find out the solutionverify if the "NT AUTHORITY\SYSTEM" has access to the database and proper rights assigned.|||[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 927: [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'restore_test' cannot be opened. It is in the middle of a restore.
[Microsoft][ODBC SQL Server Driver][SQL


Ummm ... what is the status of the database 'restore_test'?

Loading perhaps? Or suspect?|||Ummm ... what is the status of the database 'restore_test'?

Loading perhaps? Or suspect?

Yes its keep loading|||Yes 'restore_test' database is loading, please provide me help on this.

Regards,
Sumit|||If it is still loading after this much time has past, you might have a corrupt database or bad storage media.

Stop the backup. Stop the restore.

You might try RESTORE VERIFYONLY on the backup file to see if that completes.

If it does complete, it will let you know whether or not the backup file you are using for your restore is viable.

If it does not complete, then that would lead you to your storage device and it's connections to your database server.|||hi tomh,
Thanks for your suggestions, it really works.

Regards,
Sumit|||Hi,
The Problem is solved, Thanks for your valuable time.
Regards,
Sumit