Problem after attempting to import model

[minghia]

Our model is stored on a Sql Server and I tried to import a model. After I hit the button to import the model, the cursor changed to a spinning cursor and eventually Windows detects that the process is no longer responding. I killed the EA and tried to restart it. I imported the model into a new created local model and everything seemed to be okay. When I tried to connect to the Sql Server model again, I had no luck. The model appeared to load after I enter my password, as I saw the model name in the project browser, but the cursor stays as a spinning circle and eventually I get the message that the process is not responding and all I can do at this point is kill the process. Any ideas on how I reconnect to the server that I could connect to prior to the import?

[qwerty]

I'd always cross check with a native client whether a connection is possible. Also peeking into the tables (there shall be a t_object table with some contents) is useful to indicates the basics are fine.

q.

[Geert Bellekens]

Don't bother trying anything else. Just restore the last backup before things went wrong.

Geert

[minghia]

Our DB admin can get into the SQL Server database using the Microsoft client. Is there anything you can do from the client to see if there is anything wrong?

So what do I if the last backup was made after the database was corrupted? Are there any recovery tools?

[Geert Bellekens]

So what do I if the last backup was made after the database was corrupted?

Then restore the backup before that.

If you don't have a backup from before the incident, then you can try to contact sparx support, but I wouldn't be too optimistic about it.

Geert

[minghia]

I found this link https://sparxsystems.com/enterprise_architect_user_guide/15.0/model_repository/checkingdataintegrity.html but it requires that you have an opened project. If this is a possibility to happen then I would have thought that there would be an external program in EA on the server side that could do the same thing. Maybe it is just wishful thinking.

[qwerty]

Yes, it is. However, I don't shed any tears for someone not having a proper backup, you see? Things can always break. EA is rather robust and I haven't seen many cases where a model could not be recovered. But if there is a case, backups are what they are meant for.

N.B. Long ago I had a shredded hard disk. Sent it to the doctors but when they told me the recovery price I bit the dust. Or rather the bits did xD

q.

[minghia]

Interestingly enough for a supposed robust product EA allowed me to transfer the database to a local EAP file but it still won't allow me to open this newly created local project.

Where in the documentation does it explain how to restore a backup? Or do is simply a case of restoring the database as per the database backup and restore function?

[Geert Bellekens]

Interestingly enough for a supposed robust product EA allowed me to transfer the database to a local EAP file but it still won't allow me to open this newly created local project.

I'm not surprised. To do a model transfer, EA never actually opens the model. It simply connects to the database and copies each row of each table to another database.
The fact that you can't open it from an .eap file, containing the exact same data as your SQL Server model is at least consistent.

Where in the documentation does it explain how to restore a backup? Or do is simply a case of restoring the database as per the database backup and restore function?

The database is just a database. Restore using the standard restore procedure.

Geert