MSDB database does not recover and come online when restored.
Verbose log may include:
@activityIdOut error: Database 'LiteSpeedLocal' cannot be opened due to inaccessible files or insufficient memory or disk space.
@ErrorMessage='62301 : SQL Server has returned a failure message to LiteSpeed for SQL Server which has prevented the operation from succeeding.
The following message is not a LiteSpeed for SQL Server message. Please refer to SQL Server books online or Microsoft technical support for a solution:
Processed 99999 pages for database ''msdb'', file ''MSDBData'' on file 1.
Processed 9 pages for database ''msdb'', file ''MSDBLog'' on file 1.
RESTORE DATABASE is terminating abnormally.
Native SQL Server function - Setting T3608 trace flag set on sqlserver startup prevents SQL Server from automatically starting and recovering any database except the master database, it also prevents you from restoring databases manually.
See - http://msdn.microsoft.com/en-us/library/ms188396.aspx
WORKAROUND:
Remove the T3608 trace flag set on sqlserver startup
Info for 2008R2 - http://msdn.microsoft.com/en-us/library/ms345408.aspx, http://msdn.microsoft.com/en-us/library/ms190749.aspx
NOTE: This is a SQL Server error, not a result of LiteSpeed.
Remember: before restoring msdb, stop SQL Server Agent.
