Thursday, July 10, 2008

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 :)




3 comments:

Anonymous said...

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 said...

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 said...

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... ;)..