There seems to be an extra space in the database name given when it was created.
The backup job is failing with the following error message:
BACKUP failed to complete the command BACKUP DATABASE [safe_PreTMS ] TO DISK = N'S:\Full\safe_PreTMS \safe_PreTMS _db_201310021607.BAK' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
Please observe the space in the above command. When I remove the space and run the backup, it happens without any issue.
I am unable to remove the space in the DB name as well.
Can someone help me fix this issue