It’s a dirty job but someone’s gotta do it….

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 🙂

0 0 votes
Rate this article!
Subscribe
Notify of
guest

This site uses Akismet to reduce spam. Learn how your comment data is processed.

3 Comments
newest
oldest most voted
Inline Feedbacks
View all comments
Anonymous

man tackar. ett enkelt sĂ€tta att fĂ„ backup jobbet att gĂ„ igenom. Ă€ven om man undrar vad det Ă€r för FEL pĂ„ designen i sharepoint som gör att man mĂ„ste hitta asĂ„dan hĂ€r fixar. för det Ă€r ju lĂ„ngt ifrĂ„n först gĂ„ngen man mĂ„ste komma pĂ„ ett fulhack för att komma vidare… 🙂

Lise

Hehe ja, hĂ„ller med dig fullstĂ€ndigt. Man kommer alltid till en punkt i Sharepoint dĂ€r man kĂ€nner “tĂ€nkte man inte lĂ€ngre Ă€n sĂ„ hĂ€r?”. SĂ„ fĂ„r man göra sista biten sjĂ€lv 🙂
Tack för din kommentar, anonymous
keep reading 🙂

    Jorge

buen dia,

tengo el mismo, problema(moss 2007) al parecer gracias a ti tengo la solucion, pero queria saber si Âżtienes algun otro dato adicional, te ha funcionado, haz tenido algun problema causado por poner esta base de datos en blanco?
gracias, ojala me respondas.

good day
I have the same problem (Moss 2007) apparently because of you I have the solution, but wanted to know if you got some additional data, you worked, you've had a problem with this database to blank?
thanks, hopefully I respond.

desde Bogota, colombia, con cariño… ;)..