I've been asked to perform a restore of FMS database. This is just to see that it can actually be done and has been requested by SMT.
I've been in touch with a colleague who has suggested that I stop SQL, copy the ldf/mdf files and then detach the database and then reattach.
We do have SQL Management Studio Express installed which seems a much easier method but I hear there are issues with usernames and passwords.
Annoying there seems to be no documentation on it (from what I can see)
Are there any issues I should be aware of before going ahead?