Got this error in the Backup history:
Object SSO failed in event OnBackup. For more information, see the error log located in the backup directory. SqlException: Could not locate entry in sysdatabases for database ‘SSO’. No entry found with that name. Make sure that the name is entered correctly. BACKUP DATABASE is terminating abnormally.
Found out that in the Backup list there was a database called SSO that was listed for backup. But, it does not exist on the SQL server:
So, how do you edit the list of databases? I gave up searching cause I didn’t find any good answers. I wanted to be able to edit the xml file that builds the list of databases to be backed up, (like the spsbackup.xml) but that is created when you run the backup…
I did a really quick and dirty solution to this: I ended up creating an empty database called SSO on my SQL server and now, the backup runs without any errors! Sometimes you just have to be a little dirty to get things done 🙂