Restoring Eclipse Database

[Hawkeyez]

Not sure what area to post this, but..

 

We have Eclipse running on a machine running Windows Server 2008 R2. After a system failure (dont ask...), a restore was done (Symantec Backup Exec 2010 - with SQL agent)

However, this didnt restore the eclipse SQL database. After various attempts, I thought, that maybe the best route, was to get eclipse re-installed from scratch on the machine, giving a new database of same name etc.

 

This went fine, and now have a fresh install of Eclipse, however, when using Symantec to try and restore the "MLSECLIPSE" SQL database, it first sames I must set to overight the existing database, but once this is set, it just fails with a :

 

Error category : Other Errors

Error : 1 - Incorrect function.

For additional information regarding this error refer to link V-79-0-1

 

I will admit, I dont have the knowledge, and expierance in recovering a SQL database, so hoping, its just me being dumb, and missing something.

[ndavies]

What format do you have the SQL database in from restore, is it mdf and ldf or .bak?

You can use Server Management Studio to restore a backup of SQL dbs quite easily providing you have the correct credentials,