• You can rename the database to something other than the original name, then rename again to the original name without the space, eg.

    USE [master]

    sp_renamedb 'safe_PreTMS ', 'blah'

    GO

    sp_renamedb 'blah', 'safe_PreTMS'

    GO

    Obviously check to ensure your application is updated to refer to the new name and redo the backup job.