Hello-
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.
Regards,
Rajesh