Verifying SQL Server Upgrades on SQL Server Agent

When you upgrade the SQL Server to a new version, the system automatically detects and displays the newer version of SQL Server in the CommCell Console as mentioned below:

  • The SQL Server version information is refreshed and displayed in the instance Properties dialog box.

  • The next backup operation detects the new version of SQL Server.

  • The database version of the backup performed by the SQL Server Agent is displayed during the browse operation.

However, if a SQL Server instance where backups have run is upgraded to a newer version and then restored to a time prior to the SQL Server upgrade, the database displays the older version. To convert the database to a newer version, you must perform a full backup of the database after the restore.

Loading...