Hi Mike,
Thanks for posting back.
When I did a database backup it created two files, netsight and netsight.rpt file that where used to restore the database. The netsight file doesn't seem to show an extension of .sql but is 20mb in size and netsight.rpt is about 463mb.
So although I have restored the database using netsight.rpt file and all is how it was, there is still no historic Purview data, and I am not sure what .sql file you are referring to other then the ones described above. Also, how I would restore the historic purview data should there be any additional backup / sql file.
Many thanks in advance.