-
Title
SQL Attachability Check fails with "CREATE DATABASE or ALTER DATABASE failed" Error Message -
Description
Attachability fails with the following error:
Job ‘Performing attachability check for recovery point Snapshot(s) of ‘(Volume Labeled ‘RECOVERY’)',’D:\’,'E:\’,'C:\’ on ‘NAPCOCLE4′
System.AggregateException: One or more errors occurred. —> System.AggregateException: One or more errors occurred. —> Replay.Core.Contracts.Sql.DatabaseAttachabilityCheckFailedException: Attachability check failed for SQL database Prelude of instance MSSQLSERVER —> Microsoft.SqlServer.Management.Smo.FailedOperationException: Attach database failed for Server ‘NAPCOCLEB1\APPASSURE’. —> Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. —> System.Data.SqlClient.SqlException: CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database.
at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
Also, in the Event Logs on the Core you can find a lot of events with 909, 905 and 933 IDs.
-
Cause
The SQL instances on Core and Agent are different. -
Resolution
To find out the current version of your SQL instance:
- Open SQL Server Configuration Manager.
- Click SQL Server Services and select needed SQL Server in the right pane.
- RIght-Click on the SQL Server icon and go to Advanced Tab. In the field Stock Keeping Unit Name you can find you current version of the SQL instance.
If you find that you have Standard SQL edition on the Core and Enterprise SQL edition on the Agent, please upgrade Core instance to Enterprise level.
For more information on SQL Requirements for Core Instances within Rapid Recovery, click here .