Discover database to new server. process?
have moved SIMS and FMS databases onto a new server OK, but am now wondering what the correct process for moving a DISCOVER database is. Have tried to attach the database using dbattach, but it just complains the ldf log file is missing, presumably because the file name is discover_log.ldf and not discover.ldf? Renaming and trying again produces a different error.
I have tried to transfer data into a new DB, as if it was a fresh install, but at the moment the Discover Configurator is sat at waiting for service to respond. I am not sure if this is a separate issue or if something in the SIMS database from the old server already references a discover database and that's halting it. :(
What's the correct procedure here?