Existing Messagestats database are renamed if they are not upgradable
説明
Existing Messagestats database are renamed if they are not upgradable
原因
If an existing 7.x database is not removed, when running the 6.x installer, the existing Messagestats database is renamed and a new Messagestats database is created.
対策
If an existing Messagestats database is available on the SQL Server and is not upgradable, the installer would rename this database to Messagestats001 or some arbitary name and recreate a new Messagestats database.
When this happens, the database name is not expected to match the mdf and ldf filenames. Database Administrator should run the following query to confirm which mdf/ldf files belongs to the current messagestats database before removing the old database.
SELECT type_desc, physical_name FROM MessageStats.sys.database_files
