In order to troubleshoot and setup sql server for H.A we have restored latest bak copy from production to test host.
When we attempt to install applications connecting to TEST host (existing database) for some reason the installer points at the production database instead of test. Both test and production database are identical names. Are there any tables that we need to update within the test database to remove the entries from cloned production OR do we need to create a new database with installer and then export/import data from production to test database.
Any advise is much appreciated.
You would follow the steps outlined at the link below as if you were migrating the SQL database to a new server.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.