Restore of DB with Full Text Catalogs
The problem was that SQL Backup generated the script for the restore with incorrect file names for the Catalogs only. All of the normal data and log files were created correctly, the name for the object was correct, the only problem was the file name.
This primarily caused a problem when the generated file name matched another file name for a secondary data file. The restore then failed, which is I guess good. Once found the problem and cleaned up the file names, the restore worked fine.
Anyone else come across this issue?