Hello,
I have restored an octopus database from another instance but the pod is trying to create a database instead of using the restored database. We did this on our test system and it worked but the prod environment is not picking it up. I have checked and the master key is correct and the only difference between the test and prod env is the DB name and they are both hosted on the same DB instance. Could something have gone wrong with the restore?
# PROD OUTPUT
======== Initializing DB ========
Using supplied Master Key
Setting master key
Setting database connection string to: server=server;database=P_OCTOPUS;user=USER;password=********
========== SQL Database Connection Details ========
SQL Server: server
SQL Database: P_OCTOPUS
Authentication Type: SQL Server Credentials
User: USER
===================================================
Testing connection to the 'master' database...
Successfully connected to 'master' database!
Creating database 'P_OCTOPUS' on the SQL Server at 'server'
# TEST OUTPUT
======== Initializing DB ========
Using supplied Master Key
Setting master key
Setting database connection string to: server=server;database=T_OCTOPUS;user=USER;password=********
========== SQL Database Connection Details ========
SQL Server: server
SQL Database: T_OCTOPUS
Authentication Type: SQL Server Credentials
User: USER
===================================================
Testing connection to the 'master' database...
Successfully connected to 'master' database!
Database 'T_OCTOPUS' already exists on SQL Server at 'server', no need to create it.
I also did some sql queries on the DB and the information is the same on both P_OCTOPUS and T_OCTOPUS.
Best,
Ian