Backup of a SQL database with "?", "*", "'", ":" or "\" in the database name fails with The object was not found, or could not be accessed (MS SQL backup).

Article:TECH196585  |  Created: 2012-09-12  |  Updated: 2014-01-14  |  Article URL http://www.symantec.com/docs/TECH196585
NOTE: If you are experiencing this particular known issue, we recommend that you Subscribe to receive email notification each time this article is updated. Subscribers will be the first to learn about any releases, status changes, workarounds or decisions made.
Article Type
Technical Solution


Issue



When attempting to back up a database that contains a ? (question mark),  * (star), ' (single quote),  : (colon) or  a \ (back slash) in the database name will cause the backup to fail with the errors listed below or the database is not available for selection at all.

 


Error



Backup- SERVERNAME\SQLINSTANCE
Database \DATABASENAME.MDF was not found, or could not be accessed.

The debug log from the SQL Server will show the following messages:
[fsys\shared]        - Attach to SERVERNAME\INSTANCENAME                           
[fsys\sql2]          - Found database name with '?', '*', or '\'. marking it unselectable.
[fsys\sql2]          - Found database name with '?', '*', or '\'. marking it unselectable.
[fsys\sql2]          - Found database name with '?', '*', or '\'. marking it unselectable.
[fsys\sql2]          - Found database name with '?', '*', or '\'. marking it unselectable.
[fsys\sql2]          - Found database name with '?', '*', or '\'. marking it unselectable.
[fsys\sql2]          - Found database name with '?', '*', or '\'. marking it unselectable.
 


Cause



This issue is caused by having a database name with one of the characters listed above in the name

 


Solution



Currently Backup Exec does not support backing up databases that contain any of the following characters in the database name:

  • ‘    single quote
  • ?   question mark
  • \    backslash
  • :    colon
  • *   star

 

 

Workaround: Backup the database using the build in backup utility in SQL management Studio.

Note: With Backup Exe 2010 and earlier versions, database backups may have been possible of databases with these characters but restore of the databases may not be possible.

 

Symantec Corporation has acknowledged that the above-mentioned issue is present in the current version(s) listed under the Product(s) Section of this article. Symantec Corporation is committed to product quality and satisfied customers.
There are currently no plans to address this issue by way of a patch or hotfix in the current or previous versions of the software at the present time. This issue may be resolved in a future major revision of the software at a later time. However, this particular fix is not currently scheduled for any release. If you feel this issue has a direct business impact for you and your continued use of the product, please contact your Symantec Sales representative or the Symantec Sales group to discuss these concerns. For information on how to contact Symantec Sales, please see http://www.symantec.com
Please be sure to refer back to this document periodically as any changes to the status of the issue will be reflected here.

Supplemental Materials

SourceUMI
ValueV-79-57344-5891
Description

The object was not found, or could not be accessed (MS SQL backup).


SourceETrack
Value2929576
Description

SQL: Backup of a database with '?', '*', or '\' in the name causes the backup to fail.



Article URL http://www.symantec.com/docs/TECH196585


Terms of use for this information are found in Legal Notices