Restoring a copy of your Live database to Test isn't something that Support can do for you (unless you are hosted with Access) as we don't manage your SQL server, however please find the steps on how to do this below.
Making the existing Test licence available for use
Log in to the Test database in FocalPoint Administrator
On the About FocalPoint screen which appears immediately after log in, make a note of the Licence Key shown. You will need this later on
On this same screen, click Unassign Licence. You will get a warning about users not being able to log in but as you are overwriting the database anyway, you can ignore this.
Click Yes to continue. This will take you back to the login screen but will have freed up the Test licence ready to be applied to the new version of the Test database later on.
Taking a backup of the Live database
Next, your IT team will need to take a backup of the Live database and then restore that onto the SQL server, overwriting your existing Test database. They must make sure they use the same database name as the existing Test database.
Clearing out the Live licence information from the new Test database
After this is all done, IT will need to run this short script against the new Test database to clear out what was the Live licence:
-- Remove License Details - only to be run against a new Test database immediately after creation Update TS_OPTIONS Set TSO_LICENCE = ''
Licencing the new Test database
Log into the Test database in FocalPoint Administrator. When you do this for the first time after the steps above, you will be prompted with a notice about there not being a licence.
Click OK to this message. A window will appear showing all of the available licences.
Select the Test licence from the list. This is the one you made a note of at the start of this process.
Click Activate. You will be taken back to the login screen, but the licence will now have been applied and you can then log in as normal and the Test database will be fully set up.
Notes: It does seem a lot to do but should be quite straightforward when you come to carry out the steps.
The main things to note, are:
That the new Test database must overwrite the previous one and have the same name.
The new Test database must use the same licence as the original Test database did.
If either of these is not true, users on other machines will not be able to log into Test, as the licence information will not match.