When the database was checking for errors during the maintenance plan it when into recovery mode. So for the time being I just backing up the model database. ...

Just wanted to thank everyone for helping me out. Found out the issue and fixed it. The clean up was missing the file extension and location, once it...

I have put Master and model on a separate plan.

With this I still having the plan fail at the end for clean up task.

I deleted my Maintenance Plan and only selected the databases that I created and ignore Master, and model for the time being.

After running the plan it error out in the...

Results:

RESTORE DATABASE successfully processed 0 pages in 0.109 seconds (0.000 MB/sec).

Then run the Maintenace plan again,

It failed, and...

Here is something from my log files. I do run BackupExec from Symantec to do my nightly backups to tapes.

Log Name: Application

Source: ...

Okay I haven't restarted the server.

It's only me that been touch this server.

So not sure what to look for now.

I thought so, but I no expert in SQL.

So my users are able to insert records into another database in SQL, but when I perform the maintenance plan to run...