Like I said, if Restore Database (the preferred solution) fails, then importing the library root using the Add Books option I mentioned above will import all books including the saved metadata columns. If you have custom columns, the new library you are importing into must have those columns as well.
Feel free to describe exactly what the Restore reported when it failed
I am having a hard time picturing what you mean.