I had an issue upgrading v9 to v9.5 yesterday where the install error out with a SQL error "Cannot create a row of size 8067 which is greater than the allowable maximum row size of 8060".
This is now fixed, but posting for the benefit of others.
After looking through the database which was Full 2008 R2 at the time, I could see that the Backup.Model.OIBs table had a column aux_data which was a very large XML type. From what I understand this shouldn't be a problem as SQL 2005+ should support row overflow for certain data types, including XML columns. In the end I uninstalled Veeam completely, reinstalled Veeam with the local 2012 SQL express, restored config backup and then finally upgraded to v9.5. The fact that this worked, I can only guess there might be some limitation in SQL 2008??? But one to possibly be aware of.
Log from setup below:
Code: Select all
***Veeam*** SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM] [SQL|ERROR] IF EXISTS (SELECT 1 FROM [dbo].[Version] WHERE current_version >= 3441 AND current_version < 3442)
***Veeam*** SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM] [SQL|ERROR] BEGIN
***Veeam*** SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM] [SQL|ERROR] IF NOT EXISTS (SELECT * FROM syscolumns WHERE id = OBJECT_ID(N'[dbo].[Backup.Model.OIBs]') and [name] = N'creation_usn')
***Veeam*** SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM] [SQL|ERROR] BEGIN
***Veeam*** SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM] [SQL|ERROR] ALTER TABLE [dbo].[Backup.Model.OIBs] ADD [creation_usn] bigint NOT NULL DEFAULT 0
***Veeam*** SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM] [SQL|ERROR] PRINT 'New column {creation_usn} has been successfully added to [dbo].[Backup.Model.OIBs]'
***Veeam*** SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM] [SQL|ERROR] EXEC [dbo].[CreateNonClusteredIndex] N'Backup.Model.OIBs', N'creation_usn'
***Veeam*** SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM] [SQL|ERROR] END
***Veeam*** SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM] [SQL|ERROR] IF @@Error = 0 BEGIN UPDATE [dbo].[Version] SET current_version = 3442; END
***Veeam*** SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM] [SQL|ERROR] END
***Veeam*** SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM] [SQL|ERROR] GO
***Veeam*** SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM|ERROR] ExecuteNonQuery failed for Database 'Veeam2Backup'. (Microsoft.SqlServer.Management.Smo.FailedOperationException)
***Veeam*** SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM|ERROR] at Microsoft.SqlServer.Management.Smo.Database.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
***Veeam*** SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM|ERROR] at Veeam.Backup.DBCreator.DatabaseQueryExecutor.Execute(String text, Object[] args)
***Veeam*** SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM|ERROR] at Veeam.Backup.DBCreator.DatabaseScriptExecutor.Execute(String path, OnStatementExecute statementExecute)
***Veeam*** SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM|ERROR] at Veeam.Backup.DBCreator.DatabaseFileExecutor.ExecuteEscalation(DatabaseVersionType contentType)
***Veeam*** SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM|ERROR] at Veeam.Backup.DBCreator.DatabaseFileExecutor.Execute(DatabaseScriptType type)
***Veeam*** SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM|ERROR] An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Management.Common.ExecutionFailureException)
***Veeam*** SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM|ERROR] at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
***Veeam*** SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM|ERROR] at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
***Veeam*** SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM|ERROR] at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries, ExecutionTypes executionType)
***Veeam*** SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM|ERROR] at Microsoft.SqlServer.Management.Smo.Database.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
***Veeam*** SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM|ERROR] Cannot create a row of size 8067 which is greater than the allowable maximum row size of 8060.
***Veeam*** SRV: [22.11.2016 15:35:01]:<00000001> [VEEAM|ERROR] The statement has been terminated. (System.Data.SqlClient.SqlException)