How old is this backup?

- September 9th. But there is no backup.
It's a standalone workstation. Current location - my kitchen.
I'll check now if it has its own database.
There are also overdue tasks. But probably no more than 200-400 of them.
I see two projects in BOINC Manager: H@F and Gerasim@home.
I'll go to the kitchen now and see what else is there.
:)

But Gerasim crashed on August 31. Have you figured out time travel?

====
Gerasim is not the only one like this.
And each Gerasim operates with his own SQL server, or with a link to a shared SQL DB.
And it seems it's time to make a manual text copy of the Gerasim server.
Starting with "create database" and ending with "xml restore DB, countries, users, teams..." and the project on GitHub.
This should have been done a long time ago, but...
====
That's how it is, guys.
Hello everyone and have a good mood. :)

SerVal has a backup of the Gerasim databases dated 10 days prior to the crash. I downloaded the files to my linux box, installed microsoft SQL server, restored the databases, and ran dbcc to check their integrity. The databases are good. I perused some of the tables; there is a lot of data there and it all appears to be in working order.

My suggestion is to use these backups to restore the databases on the Gerasim server. This would leave us with only 10 days of lost credit. I already have the results from about 5 days prior to the crash, so it doesn't help with that.
1. I would help with this myself, but am not familiar with Microsoft databases. Maybe someone else familiar with database administration on Microsoft could help. It's a matter of getting SerVal's permission, logging in remotely, and then doing the restore.
2. I think SerVal has some backend scripts for doing various functions, and he might want to get that working first before restoring the databases. For example, I upload tasks via a zip file and the website automatically generates the work. I believe much of this is SerVal's home brew and I don't understand how it interfaces with the normal BOINC server. That makes it hard to help, not to mention the language barrier.

Hopefully this can get the discussion going...

If I can get a copy of this database I can see what I can do on it. I'm not familiar with Microsoft databases, but have some pretty decent knowledge on MySQL/MariaDB. I maintain a rather large one after all.

What I would probably end up doing is just converting that database to MySQL since that's what BOINC uses natively anyway. Getting it setup and working in a Linux environment. Then figuring out how to export that data in a format that Microsoft datbase can use or just running the project with Linux and the native BOINC Linux server like it was intended in the first place.

Assuming the database isn't damaged beyond repair though.

Their are already tools available to convert MSSQL to MySQL and vise verse. Its just a matter of making sure the database isn't corrupted before doing so. Otherwise you'll have to repair the database.

SerVal has a backup of the Gerasim databases dated 10 days prior to the crash. I downloaded the files to my linux box, installed microsoft SQL server, restored the databases, and ran dbcc to check their integrity. The databases are good. I perused some of the tables; there is a lot of data there and it all appears to be in working order.

My suggestion is to use these backups to restore the databases on the Gerasim server. This would leave us with only 10 days of lost credit. I already have the results from about 5 days prior to the crash, so it doesn't help with that.
1. I would help with this myself, but am not familiar with Microsoft databases. Maybe someone else familiar with database administration on Microsoft could help. It's a matter of getting SerVal's permission, logging in remotely, and then doing the restore.
2. I think SerVal has some backend scripts for doing various functions, and he might want to get that working first before restoring the databases. For example, I upload tasks via a zip file and the website automatically generates the work. I believe much of this is SerVal's home brew and I don't understand how it interfaces with the normal BOINC server. That makes it hard to help, not to mention the language barrier.

Hopefully this can get the discussion going...

If I can get a copy of this database I can see what I can do on it. I'm not familiar with Microsoft databases, but have some pretty decent knowledge on MySQL/MariaDB. I maintain a rather large one after all.

What I would probably end up doing is just converting that database to MySQL since that's what BOINC uses natively anyway. Getting it setup and working in a Linux environment. Then figuring out how to export that data in a format that Microsoft datbase can use or just running the project with Linux and the native BOINC Linux server like it was intended in the first place.

Assuming the database isn't damaged beyond repair though.

Their are already tools available to convert MSSQL to MySQL and vise verse. Its just a matter of making sure the database isn't corrupted before doing so. Otherwise you'll have to repair the database.

I have copies of the backups that I could get to you. They are ~3.7 GB so I will need to upload them to Google Drive.

Note there are 2 databases - the standard BOINC database and then a science database where results were stored. I'm pretty sure they are good since they passed the dbcc check with no errors.

But what is the objective here? Converting to MySQL does no good if SerVal plans to host Gerasim as he has in the past, using microshit SQL.

Its with my understanding that the hacked up job of getting a BOINC Server running on Windows isn't working. No one knows how to fix this as it's a territory no one has done before except the Gerasim project. Since the database is in MSSQL just running it on Linux wont be possible afaik and it will need to be converted to MySQL.

No one knows how to fix this
But if you want to, you can try.
Does MySQL have insert, select, update, and execute stored procedure?
I can tell you how do it without convert DB -> <- туда сюда и обратно. :)

I have over a decade of experience with microsoft SQL and servers.

Serval, I can help. Will need to ask you some questions. I'd prefer to get onto an instant messenger like Discord or whatsapp to discuss

Just read more of the thread. Microsoft SQL can absolutely be run on linux fully natively. Its not 2010 anymore😆

I have over a decade of experience with microsoft SQL and servers.

Serval, I can help. Will need to ask you some questions. I'd prefer to get onto an instant messenger like Discord or whatsapp to discuss

If you can work with SerVal and figure out what he needs, that would be great.

But I think we still need a game plan. From my understanding, the problem is more than the database. Here's what I think needs to be done:
1. Get the Gerasim server working as it was before, with a new empty database. This is the hard part because SerVal is doing this under windows but BOINC was designed for linux. For this reason, most project admins don't have a clue how to help.
2. Use the backups of the old database to restore all the user accounts and their credits. This *should* be easy for an expert with MS-SQL.

I have over a decade of experience with Microsoft SQL and servers.
Microsoft SQL can absolutely be run on Linux fully natively. It's not 2010 anymore.
I have no doubt. But why?
====
I would prefer to discuss this in a messenger, for example, in Discord or WhatsApp.
* Google is heavily restricted in Russia. And Discord, WhatsApp and VPN are completely banned. :(
====
Maybe we should start here using PM? We can't do without Eric anyway.
I don't even have WU for testing - 2-3k...
Write your questions in PM and I will definitely answer them.
Regards, SerVal
====
p.s. I don't write English well, but I think better than you write in Russian. :)

I don't even have WU for testing - 2-3k...

I will get you some WUs for testing.