Moving Database in 7.1
Happy new year all!
A new year brings new problems and hopefully new solutions
We are trying to move our database from one SQ L2005 server to another, previously we have simply backed up and moved the database to the new server, then stopped all Altiris services on the NS server, then entered the new SQL server name and told it to use the existing database.
What is happening now is when I click on save changes to use the existing database, it goes through process of upgrading the database this eventually completes but an error flashes up quickly followed by a completed successfully window. It then reverts back to the old database settings.
Looking in the Log Viewer shows amongst other errors "upgrade of database, post install, was not fully successful" Violation of Primary key constraint.
Has anyone else seen this when moving their database, we're using NS7.1 and SQL 2005 server.