-
Title
LiteSpeed cannot backup a database with name containing a dash '-', slash '/', comma ',' or a dot -
Description
LiteSpeed cannot backup a database with name containing a dash '-', slash '/', comma ',' or a dot '.' (or period)
Error message similar to this may appear in the LiteSpeed verbose error log file:
Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3068
Maintenance Plan: Backup All User DBs
Duration: 00:01:21
Status: Warning: One or more tasks failed..
Details:
Back Up Database 1 (7TZXKF1)
Back up database using LiteSpeed.
Back up database on Local server connection.
Databases: (All user databases)
Task start: 2008-08-14T14:51:12.
Task end: 2008-08-14T14:52:33.
...
" failed with the following error: "SQL Server has returned a failure message to LiteSpeed which has prevented the operation from succeeding.
The following message is not a LiteSpeed message. Please refer to SQL Server books online or Microsoft technical support for a solution:
BACKUP DATABASE is terminating abnormally.
Could not locate entry in sysdatabases for database 'QUEST_QA_TEMP_CONTENT_B71BB5DA__1306400393'. No entry found with that name. Make sure that the name is entered correctly. -
Cause
Product defect.
-
Resolution
Fixed in Version 5.0.1 of LiteSpeed.
-
Defect ID
ST52947 ST53899 -
Additional Information
Quest Software's Recovery Manager for SharePoint creates databases named with the dash or underscore. These databases may be excluded from the LiteSpeed maintenance plans for backup. TheRM_Cache_######is used for catalogue information about SharePoint Backups registered in Recovery Manager for SharePoint, this could be deleted without much impact so we don’t bother backing it up. TheRM_TEMP_CONTENT_######_######is exactly that, temporary. This should be deleted often as it will grow out of control. An new DB with different #’s would be generated on the fly if both of these DBs are removed.