Is there a link or write-up that I can refer to do this?

We create test database from a backup copy of production database every weekend. I want to find out whether there is a way I can find the last refresh/restore date...

I mean not connecting to the litespeed console. We have about 65 databases that we need to setup the backup/restore jobs. Is there a way I can run some...

Thank you very much for all the help - we're able to fix the issue now. After going through the error log, like many of you suggested, we found out...

This backup is taken by a Litespeed stored procedure (setup by a consultant). I don't have the full code/details on the stored procedure. What is the best way to pull...

I ran the query and it returned backup_finish_date with three rows - last night, night before and the night before that.

Does it mean that my backup ran fine? Is...

Output from Job Steps -> Advanced -> output to a file:

Msg 1, Sev 16, State 1: LiteSpeed(R) for SQL Server Version 6.5.1.1018 Copyright 2011 Quest Software, Inc. Processed 53312 pages...

SQLServer error.log did not show any relevant info:

2011-11-22 17:49:26.66 Backup Database backed up. Database: MED_PROD, creation date(time): 2011/09/15(13:37:38), pages dumped: 14213712, first LSN: 523142:20326:56, last...

dbcc checkdb with NO_INFOMSGS did not bring any errors at all.

Job History log viewer does not show any error other than the one I posted. What else should I try?

Software,...

dbcc checkdb did not find any errors. It came back saying 0 erorrs found.

Log only shows the error that I posted earlier.

Maintenance plan design window is the one that appears when I double-click this maintenance plan.

I don't have an Execute command in the menu if I right click the History Cleanup...

Is it possible to run the History Cleanup task alone to troubleshoot? How do I log to a file?