Can I move the Archive Manager database to a SQL server with a different collation? (84252)

There may be a time when the Archive Manager database needs to be moved to a different SQL server for any number of reasons and many SQL servers utilize a different collation than that which is required by Archive Manager.

The ArchiveManager database and the AfterMail_TEMP database can be moved to a SQL server that uses a different collation however, both of these databases must maintain the SQL_Latin1_General_CP1_CI_AS collation.

Example: The SQL server itself may have a collation of 'Latin1_General_CI_AS' as that may be a requirement for most of the databases that will be created on the server which is fine as long as the ArchiveManager database and the AfterMail_TEMP databases both have 'SQL_Latin1_General_CP1_CI_AS collation' collation.