Whoa, this is interesting...

My first attempt to move the DB was to simply copy over the FDB. That didn't work, so that's when I went down the nbackup rabbit hole. As it turns out, nbackup is the problem, not the solution...

When I tried to re-attach the FDB file on the new server I got a "file not found" error. But looking in some of the logging files I found...

Reason: I/O error for file CreateFile (open) "D:\FISHBOWL\DATABASE\DATA\ASSOLAR.FDB.delta"
Error while trying to open file
null

Ahhhh. Notice *which* file it can't find?

Well then, perhaps if I copy BOTH files over... and it works!

So basically it seems that the FDB file contains some sort of information that points to the delta. When you attempt to connect to a FDB in this state, it also looks for that delta file, and if it's not there, you get "file not found". Makes sense in retrospect!

I then used isql to ALTER DATABASE END BACKUP. This took about 15 seconds to run (impressive!), and successfully merged the delta back into the FDB. Everything is back to normal. Yay!

This is definitely something that should be mentioned in the documentation! Is there a method for me to do the documentation change? I'm pretty good at that sort of thing.

p.s. Now that I'm running, does anyone have any suggestions on any post-move maintenance I might want to do?