SQL server Upgrade

 

When you upgrade to a new version of SQL Server, there are some critical things you should do to help avoid any surprise SQL Server performance issues. I mean new version  of SQL Server is 2016,2017 or 2019, Because Microsoft  closed its support up to some extent to older version

Why need the Requirement to upgrade the Version?

Basically it is because Microsoft ended Its support of some versions.

There are two type of Support

1- MainStream Support

2- Extended Support

SQL Server Versions	MainStream Support	Extended Support
SQL Server 2005	April 12, 2011	April 12, 2016
SQL Server 2008 or R2	July 8, 2014	July 9,2019
SQL Server 2012	July 11, 2017	July 12, 2022
SQL Server 2014	July 9, 2019	July 9, 2024
SQL Server 2016	July 13, 2021	July 14, 2026
SQL Server 2017	Oct 11, 2022	Oct 12, 2027
SQL Server 2019	July 1, 2025	Aug 1, 2030

For Upgrading any Version there are some preparations which need to be taken care.

1- Find the Upgrade Blockers. 

2- Clear Understanding of Version and Editions.

3- Clear Understanding of Features introduced and obsolete

3- Make a List of objects which use the features which  are obsolete from the newer version and currently in use.

4- Clear Hardware Requirement for newer Versions. 

For this Activity i am upgrading the Server from 2012 to 2017.

Process to Upgrade the SQL Server Version.

There are 3 ways to upgrade

1. - In-Place Upgrade

2. - Side-by-Side Upgrade

3. - Rolling Upgrade

Steps for an In-Place Upgrade 

In-place upgrades are the easiest to perform, but the most difficult to rollback should there be any issues. The steps involved in an in-place upgrade are as follows:

1. Verify that backups exist for all databases (user and system). 

2. Review the list of requirements for SQL server 2017 and install whatever is needed.

3. Install SQL Server 2017 

4. Restore the Backup

Side-by-Side Upgrade

• 1- Backup all the database

• 2-Script out any and all necessary system objects.

            3-Review the list of requirements for SQL server 2017 and install whatever is needed.

• 4- Run the script to create the Object

• 5-Select database(s) to migrate and it take offline. 

• 6-Migrate database to new instance. Repeat for each database.

•  

 

 

 

Rolling Upgrade

1- Select any High-Availability 

2- Install new Server instance 2017 and make it  as a Secondary node

3- Fail the Primary Node now New Instance will be active and will be Primary Node

 

Checklist need to Perform Before Planning to Upgrade about version of Server

1-Checking of Deprecated Features  in new version

SELECT * FROM sys.dm_os_performance_counters   WHERE object_name  = 'MSSQL$JFT:Deprecated Features   

2- Get the List top indexes which are in use maximum times in the current version.

SELECT OBJECT_NAME(IX.OBJECT_ID) Table_Name

      ,IX.name                     AS Index_Name

      ,IX.type_desc                 AS Index_Type

      ,SUM(PS.[used_page_count]) * 8     IndexSizeKB

      ,IXUS.user_seeks AS             NumOfSeeks

      ,IXUS.user_scans AS             NumOfScans

      ,IXUS.user_lookups AS             NumOfLookups

      ,IXUS.user_updates AS             NumOfUpdates

      ,IXUS.last_user_seek AS         LastSeek

      ,IXUS.last_user_scan AS         LastScan

      ,IXUS.last_user_lookup AS         LastLookup

      ,IXUS.last_user_update AS         LastUpdate

FROM sys.indexes IX

INNER JOIN sys.dm_db_index_usage_stats IXUS 

ON IXUS.index_id = IX.index_id AND IXUS.OBJECT_ID = IX.OBJECT_ID

INNER JOIN sys.dm_db_partition_stats PS 

on PS.object_id=IX.object_id

WHERE OBJECTPROPERTY(IX.OBJECT_ID,'IsUserTable') = 1

GROUP BY 

OBJECT_NAME(IX.OBJECT_ID) ,

IX.name ,

IX.type_desc ,

IXUS.user_seeks ,

IXUS.user_scans ,

IXUS.user_lookups,

IXUS.user_updates ,

IXUS.last_user_seek ,

IXUS.last_user_scan ,

IXUS.last_user_lookup ,

IXUS.last_user_update

3- Current Used Space at current instance and Available Space in the new instance.

4- Current OS Hardware Configuration.

5- Scripting of all user defined Objects.

 

SQL Error Type List with description from error 500 to 1000

Error Type =502,/n Error Description The SQL Debugging Interface (SDI) requires that SQL Server, when started as a service, must not log on as System Account. Reset to log on as user account using Control Panel.. Error Severity  Level=16

Error Type =503, Error Description Unable to send symbol information to debugger on %ls for connection %d. Debugging disabled.. Error Severity  Level=16

Error Type =504, Error Description Unable to connect to debugger on %ls (Error = 0x%08x). Ensure that client-side components, such as SQLDBREG.EXE, are installed and registered on %.*ls. Debugging disabled for connection %d.. Error Severity  Level=16

Error Type =505, Error Description The current user account was invoked with SETUSER or SP_SETAPPROLE. Changing databases is not allowed.. Error Severity  Level=16

Error Type =506, Error Description The invalid escape character "%.*ls" was specified in a %ls predicate.. Error Severity  Level=16

Error Type =507, Error Description Invalid argument for SET ROWCOUNT. Must be a non-null non-negative integer.. Error Severity  Level=16

Error Type =508, Error Description Unable to connect to debugger on %ls (Error = 0x%08x). Ensure that client-side components, such as SQLLE.DLL, are installed and registered on %.*ls. Debugging disabled for connection %d.. Error Severity  Level=16

Error Type =509, Error Description User name '%.*ls' not found.. Error Severity  Level=11

Error Type =510, Error Description Cannot create a worktable row larger than allowable maximum. Resubmit your query with the ROBUST PLAN hint.. Error Severity  Level=16

Error Type =511, Error Description Cannot create a row of size %d which is greater than the allowable maximum of %d.. Error Severity  Level=16

Error Type =512, Error Description Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.. Error Severity  Level=16

Error Type =513, Error Description A column insert or update conflicts with a rule imposed by a previous CREATE RULE statement. The statement was terminated. The conflict occurred in database '%.*ls', table '%.*ls', column '%.*ls'.. Error Severity  Level=16

Error Type =514, Error Description Unable to communicate with debugger on %ls (Error = 0x%08x). Debugging disabled for connection %d.. Error Severity  Level=16

Error Type =515, Error Description Cannot insert the value NULL into column '%.*ls', table '%.*ls'; column does not allow nulls. %ls fails.. Error Severity  Level=16

Error Type =516, Error Description Attempt to initialize OLE library failed. Check for correct versions of OLE DLLs on this machine.. Error Severity  Level=16

Error Type =517, Error Description Adding a value to a '%ls' column caused overflow.. Error Severity  Level=16

Error Type =518, Error Description Cannot convert data type %ls to %ls.. Error Severity  Level=16

Error Type =520, Error Description SQL Server no longer supports version %d of the SQL Debugging Interface (SDI).. Error Severity  Level=16

Error Type =522, Error Description The WAITFOR thread was evicted.. Error Severity  Level=16

Error Type =523, Error Description A trigger returned a resultset and/or was running with SET NOCOUNT OFF while another outstanding result set was active.. Error Severity  Level=16

Error Type =524, Error Description A trigger returned a resultset and the server option 'disallow results from triggers' is true.. Error Severity  Level=16

Error Type =525, Error Description The column that was returned from the nodes() method cannot be converted to the data type %ls. It can only be used with one of the four XML data type methods, exist(), nodes(), query(), and value(), or in IS NULL and IS NOT NULL checks.. Error Severity  Level=16

Error Type =526, Error Description %ls of XML types constrained by different XML schema collections and/or DOCUMENT/CONTENT option is not allowed. Use the CONVERT function to run this query.. Error Severity  Level=16

Error Type =527, Error Description Implicit conversion between XML types constrained by different XML schema collections is not allowed. Use the CONVERT function to run this query.. Error Severity  Level=16

Error Type =528, Error Description System error detected during attempt to use the 'upsleep' system function.. Error Severity  Level=16

Error Type =529, Error Description Explicit conversion from data type %ls to %ls is not allowed.. Error Severity  Level=16

Error Type =530, Error Description The statement terminated. The maximum recursion %d has been exhausted before statement completion.. Error Severity  Level=16

Error Type =531, Error Description Cannot set NOCOUNT to OFF inside the trigger execution because the server option "disallow_results_from_triggers" is true or we are inside LOGON trigger execution.. Error Severity  Level=10

Error Type =532, Error Description The timestamp (changed to %S_TS) shows that the row has been updated by another user.. Error Severity  Level=16

Error Type =533, Error Description Cannot set XACT ABORT to OFF inside the trigger execution unless the database compatibility is 90.. Error Severity  Level=10

Error Type =534, Error Description %.*ls' failed because it is not supported in the edition of this SQL Server instance '%.*ls'. See books online for more details on feature support in different SQL Server editions.. Error Severity  Level=16

Error Type =535, Error Description Difference of two datetime columns caused overflow at runtime.

 The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart.. Error Severity  Level=16"

 

Error Type =536, Error Description Invalid length parameter passed to the substring function.. Error Severity  Level=16

Error Type =537, Error Description Invalid length parameter passed to the LEFT or SUBSTRING function.. Error Severity  Level=16

Error Type =538, Error Description Cannot find '%.*ls'. This language may have been dropped. Contact your system administrator.. Error Severity  Level=16

Error Type =539, Error Description Schema changed after the target table was created. Rerun the Select Into query.. Error Severity  Level=16

Error Type =540, Error Description There is insufficient system memory to run RAISERROR.. Error Severity  Level=16

Error Type =541, Error Description There is not enough stack to execute the statement. Error Severity  Level=16

Error Type =542, Error Description An invalid datetime value was encountered. Value exceeds the year 9999.. Error Severity  Level=16

Error Type =543, Error Description Creation of a return table failed for the table valued function '%.*ls'.. Error Severity  Level=16

Error Type =544, Error Description Cannot insert explicit value for identity column in table '<Table Name>' when IDENTITY_INSERT is set to OFF.. Error Severity  Level=16

Error Type =545, Error Description Explicit value must be specified for identity column in table '<Table Name>' when IDENTITY_INSERT is set to ON.. Error Severity  Level=16

"Error Type =547, Error Description INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'Constraint Name'.For more details

 UPDATE statement conflicted with COLUMN REFERENCE constraint 'Constraint Name'.

 DELETE statement conflicted with COLUMN REFERENCE constraint 'Constraint Name'.

 ALTER TABLE statement conflicted with COLUMN REFERENCE constraint 'Constraint Name'.. Error Severity  Level=16"

 

 

Error Type =548, Error Description The identity range managed by replication is full and must be updated by a replication agent. The %ls conflict occurred in database '%.*ls', table '%.*ls'%ls%.*ls%ls. Sp_adjustpublisheridentityrange can be called to get a new identity range.. Error Severity  Level=16

Error Type =549, Error Description The collation '%.*ls' of receiving variable is not equal to the collation '%.*ls' of column '%.*ls'.. Error Severity  Level=16

Error Type =550, Error Description The attempted insert or update failed because the target view either specifies WITH CHECK OPTION or spans a view that specifies WITH CHECK OPTION and one or more rows resulting from the operation did not qualify under the CHECK OPTION constraint.. Error Severity  Level=16

Error Type =551, Error Description The checksum has changed to %d. This shows that the row has been updated by another user.. Error Severity  Level=16

Error Type =552, Error Description CryptoAPI function "%ls" failed. Error 0x%x: %ls. Error Severity  Level=16

Error Type =555, Error Description User-defined functions are not yet enabled.. Error Severity  Level=16

Error Type =556, Error Description INSERT EXEC failed because the stored procedure altered the schema of the target table.. Error Severity  Level=16

Error Type =557, Error Description Only functions and extended stored procedures can be executed from within a function.. Error Severity  Level=16

Error Type =558, Error Description Remote function calls are not allowed within a function.. Error Severity  Level=16

Error Type =561, Error Description Failed to access file '%.*ls'. Error Severity  Level=16

Error Type =562, Error Description Failed to access file '%.*ls'. Files can be accessed only through shares. Error Severity  Level=16

Error Type =563, Error Description The transaction for the INSERT EXEC statement has been rolled back. The INSERT EXEC operation will be terminated.. Error Severity  Level=14

Error Type =564, Error Description Attempted to create a record with a fixed length of '%d'. Maximum allowable fixed length is '%d'.. Error Severity  Level=16

Error Type =566, Error Description Error writing audit trace. SQL Server is shutting down.. Error Severity  Level=21

Error Type =565, Error Description The server encountered a stack overflow during compile time.. Error Severity  Level=18

Error Type =567, Error Description File '%.*ls' either does not exist or is not a recognizable trace file. Or there was an error opening the file.. Error Severity  Level=16

Error Type =568, Error Description Server encountered an error '%.*ls'.. Error Severity  Level=16

Error Type =569, Error Description The handle that was passed to %ls was invalid.. Error Severity  Level=16

Error Type =570, Error Description INSTEAD OF triggers do not support direct recursion. The trigger execution failed.. Error Severity  Level=15

Error Type =571, Error Description The specified attribute value for %ls is invalid.. Error Severity  Level=16

Error Type =572, Error Description Invalid regular expression "%.*ls" near the offset %d.. Error Severity  Level=16

Error Type =573, Error Description Evaluation of the regular expression is too complex: '%.*ls'.. Error Severity  Level=16

Error Type =574, Error Description %ls statement cannot be used inside a user transaction.. Error Severity  Level=16

Error Type =575, Error Description A LOGON trigger returned a resultset. Modify the LOGON trigger to not return resultsets.. Error Severity  Level=16

Error Type =576, Error Description Cannot create a row that has sparse data of size %d which is greater than the allowable maximum sparse data size of %d.. Error Severity  Level=16

Error Type =577, Error Description The value provided for the timeout is not valid. Timeout must be a valid integer between 0 and 2147483647.. Error Severity  Level=16

Error Type =578, Error Description Insert Exec not allowed in WAITFOR queries.. Error Severity  Level=16

Error Type =579, Error Description Can not execute WAITFOR query with snapshot isolation level.. Error Severity  Level=16

Error Type =582, Error Description Offset is greater than the length of the column to be updated in write.. Error Severity  Level=16

Error Type =583, Error Description Negative offset or length in write.. Error Severity  Level=16

Error Type =584, Error Description Select Into not allowed in WAITFOR queries.. Error Severity  Level=16

Error Type =585, Error Description Changing database context is not allowed when populating the resource database.. Error Severity  Level=16

Error Type =587, Error Description An invalid delayed CLR type fetch token is provided.. Error Severity  Level=16

Error Type =588, Error Description Multiple tasks within the session are using the same delayed CLR type fetch token at the same time.. Error Severity  Level=16

Error Type =589, Error Description This statement has attempted to access data whose access is restricted by the assembly.. Error Severity  Level=16

Error Type =590, Error Description RPC was aborted without execution.. Error Severity  Level=16

Error Type =591, Error Description %ls: The formal parameter "%ls" was defined as OUTPUT, but the actual parameter was not declared as OUTPUT.. Error Severity  Level=16

Error Type =592, Error Description Cannot find %S_MSG ID %d in database ID %d.. Error Severity  Level=16

Error Type =593, Error Description fn_trace_gettable: XML conversion of trace data for event 165 failed.. Error Severity  Level=10

Error Type =594, Error Description fn_trace_gettable: XML conversion of trace data is not supported in fiber mode.. Error Severity  Level=10

Error Type =595, Error Description Bulk Insert with another outstanding result set should be run with XACT_ABORT on.. Error Severity  Level=16

Error Type =596, Error Description Cannot continue the execution because the session is in the kill state.. Error Severity  Level=16

Error Type =597, Error Description The execution of in-proc data access is being terminated due to errors in the User Datagram Protocol (UDP).. Error Severity  Level=16

Error Type =598, Error Description An error occurred while executing CREATE/ALTER DB. Please look at the previous error for more information.. Error Severity  Level=16

Error Type =599, Error Description %.*ls: The length of the result exceeds the length limit (2GB) of the target large type.. Error Severity  Level=16

Error Type =601, Error Description Could not continue scan with NOLOCK due to data movement.. Error Severity  Level=12

Error Type =602, Error Description Could not find row in sysindexes for database ID %d, object ID %ld, index ID %d. Run DBCC CHECKTABLE on sysindexes.. Error Severity  Level=21

Error Type =603, Error Description Could not find an entry for table or index with object ID %d (partition ID %I64d) in database %d. This error can occur if a stored procedure references a dropped table, or metadata is corrupted. Drop and re-create the stored procedure, or execute DBCC CHE. Error Severity  Level=21

Error Type =604, Error Description Could not find row in sysobjects for object ID %ld in database '%.*ls'. Run DBCC CHECKTABLE on sysobjects.. Error Severity  Level=21

Error Type =605, Error Description Attempt to fetch logical page %S_PGID in database '%.*ls' belongs to object '%.*ls', not to object '%.*ls'.. Error Severity  Level=21

Error Type =606, Error Description Metadata inconsistency. Filegroup id %ld specified for table '%.*ls' does not exist. Run DBCC CHECKDB or CHECKCATALOG.. Error Severity  Level=21

Error Type =607, Error Description Insufficient room was allocated for search arguments in the session descriptor for object '%.*ls'. Only %d search arguments were anticipated.. Error Severity  Level=21

Error Type =608, Error Description No catalog entry found for partition ID %I64d in database %d. The metadata is inconsistent. Run DBCC CHECKDB to check for a metadata corruption.. Error Severity  Level=16

Error Type =609, Error Description BTree is not empty when waking up on RowsetBulk.. Error Severity  Level=16

Error Type =610, Error Description Invalid header value from a page. Run DBCC CHECKDB to check for a data corruption.. Error Severity  Level=16

Error Type =611, Error Description Cannot insert or update a row because total variable column size, including overhead, is %d bytes more than the limit.. Error Severity  Level=16

Error Type =613, Error Description Could not find an entry for worktable rowset with partition ID %I64d in database %d.. Error Severity  Level=21

Error Type =615, Error Description Could not find database table ID %d, name '%.*ls'.. Error Severity  Level=21

Error Type =617, Error Description Descriptor for object ID %ld in database ID %d not found in the hash table during attempt to unhash it.. Error Severity  Level=20

Error Type =618, Error Description A varno of %d was passed to the opentable system function. The largest valid value is %d.. Error Severity  Level=21

Error Type =622, Error Description Filegroup '%.*ls' has no files assigned to it. Tables, indexes, and text, ntext, and image columns cannot be populated on this filegroup until a file is added.. Error Severity  Level=16

Error Type =623, Error Description Could not retrieve row from page by RID because logical page %S_PGID is not a data page. %S_RID. %S_PAGE.. Error Severity  Level=21

Error Type =624, Error Description Could not retrieve row from page by RID because the requested RID has a higher number than the last RID on the page. %S_RID.%S_PAGE, DBID %d.. Error Severity  Level=21

Error Type =625, Error Description Cannot retrieve row from page %S_PGID by RID because the slotid (%d) is not valid.. Error Severity  Level=21

Error Type =626, Error Description Cannot use ROLLBACK with a savepoint within a distributed transaction.. Error Severity  Level=16

Error Type =627, Error Description Cannot use SAVE TRANSACTION within a distributed transaction.. Error Severity  Level=16

Error Type =628, Error Description Cannot issue SAVE TRANSACTION when there is no active transaction.. Error Severity  Level=13

Error Type =635, Error Description Process %d tried to remove DES resource lock %S_DES, which it does not hold.. Error Severity  Level=20

Error Type =637, Error Description Index shrink program returned invalid status of 0.. Error Severity  Level=20

Error Type =639, Error Description Could not fetch logical page %S_PGID, database ID %d. The page is not currently allocated.. Error Severity  Level=21

Error Type =644, Error Description Could not find the index entry for RID '%.*hs' in index page %S_PGID, index ID %d, database '%.*ls'.. Error Severity  Level=21

Error Type =649, Error Description Could not find the clustered index entry for page %S_PGID, object ID %ld, status 0x%x. Index page %S_PGID, in database '%.*ls', was searched for this entry.. Error Severity  Level=21

Error Type =650, Error Description You can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ isolation levels.. Error Severity  Level=16

Error Type =651, Error Description Cannot use %hs granularity hint on table '%.*ls' because locking at the specified granularity is inhibited.. Error Severity  Level=16

Error Type =652, Error Description Index ID %d for table '%.*ls' resides on a read-only filegroup which cannot be modified.. Error Severity  Level=16

Error Type =653, Error Description Two buffers are conflicting for the same keep slot in table '%.*ls'.. Error Severity  Level=20

Error Type =654, Error Description No slots are free to keep buffers for table '%.*ls'.. Error Severity  Level=20

Error Type =655, Error Description Expected to find buffer in keep slot for table '%.*ls'.. Error Severity  Level=20

Error Type =656, Error Description The partitioning function '%.*ls' creates %d partitions, which prevents removal of increased partitions support.. Error Severity  Level=10

Error Type =657, Error Description Could not disable support for increased partitions in database '%.*ls' because %S_MSG.. Error Severity  Level=16

Error Type =658, Error Description Could not enable support for increased partitions in database '%.*ls' because %S_MSG.. Error Severity  Level=16

Error Type =666, Error Description Maximum system-generated unique value for a duplicate group exceeded for table ID %d, index ID %d. Dropping and re-creating the index may fix the problem; otherwise use another clustering key.. Error Severity  Level=16

Error Type =667, Error Description Index %d for table '%.*ls' resides on offline filegroup that cannot be accessed.. Error Severity  Level=16

Error Type =669, Error Description The row object is inconsistent. Please rerun the query.. Error Severity  Level=22

Error Type =670, Error Description Large object (LOB) data for table "%.*ls" resides on an offline filegroup ("%.*ls") that cannot be accessed.. Error Severity  Level=16

Error Type =671, Error Description Large object (LOB) data for table "%.*ls" resides on a read-only filegroup ("%.*ls"), which cannot be modified.. Error Severity  Level=16

Error Type =672, Error Description Failed to queue cleanup packets for orphaned rowsets in database "%.*ls". Some disk space may be wasted. Cleanup will be attempted again on database restart.. Error Severity  Level=10

Error Type =674, Error Description Exception occurred in destructor of RowsetNewSS 0x%p. This error may indicate a problem related to releasing pre-allocated disk blocks used during bulk-insert operations. Restart the server to resolve this problem.. Error Severity  Level=10

Error Type =675, Error Description Worktable with partition ID %I64d was dropped successfully after repeated attempts.. Error Severity  Level=10

Error Type =676, Error Description Error occurred while attempting to drop worktable with partition ID %I64d.. Error Severity  Level=10

Error Type =677, Error Description Unable to drop worktable with partition ID %I64d after repeated attempts. Worktable is marked for deferred drop. This is an informational message only. No user action is required.. Error Severity  Level=10

Error Type =678, Error Description Active rowset for partition ID %I64d found at the end of the batch. This error may indicate incorrect exception handling. Use the current activity window in SQL Server Management Studio or the Transact-SQL KILL statement to terminate the server process id. Error Severity  Level=10

Error Type =679, Error Description One of the partitions of index '%.*ls' for table '%.*ls'(partition ID %I64d) resides on a filegroup ("%.*ls") that cannot be accessed because it is offline, restoring, or defunct. This may limit the query result.. Error Severity  Level=16

Error Type =680, Error Description Error [%d, %d, %d] occurred while attempting to drop allocation unit ID %I64d belonging to worktable with partition ID %I64d.. Error Severity  Level=10

Error Type =681, Error Description Attempting to set a non-NULL-able column's value to NULL.. Error Severity  Level=16

Error Type =682, Error Description Internal error. Buffer provided to read column value is too small. Run DBCC CHECKDB to check for any corruption.. Error Severity  Level=16

Error Type =683, Error Description An internal error occurred while trying to convert between variable-length and fixed-length decimal formats. Run DBCC CHECKDB to check for any database corruption.. Error Severity  Level=22

Error Type =684, Error Description An internal error occurred while attempting to convert between compressed and uncompressed storage formats. Run DBCC CHECKDB to check for any corruption.. Error Severity  Level=22

Error Type =685, Error Description An internal error occurred while attempting to retrieve a backpointer for a heap forwarded record.. Error Severity  Level=22

Error Type =, Error Description Syntax error converting datetime from character string.. Error Severity  Level=16

Error Type =701, Error Description There is insufficient system memory to run this query.. Error Severity  Level=19

Error Type =708, Error Description Warning: Due to low virtual memory, special reserved memory used %d times since startup. Increase virtual memory on server.. Error Severity  Level=10

Error Type =801, Error Description A buffer was encountered with an unexpected status of 0x%x.. Error Severity  Level=20

Error Type =802, Error Description No more buffers can be stolen.. Error Severity  Level=17

Error Type =803, Error Description simulated failure (DEBUG only). Error Severity  Level=10

Error Type =804, Error Description Could not find buffer 0x%lx holding logical page %S_PGID in the SDES 0x%lx kept buffer pool for object '%.*ls'.. Error Severity  Level=20

Error Type =805, Error Description restore pending. Error Severity  Level=10

Error Type =806, Error Description audit failure (a page read from disk failed to pass basic integrity checks). Error Severity  Level=10

Error Type =807, Error Description (no disk or the wrong disk is in the drive). Error Severity  Level=10

Error Type =808, Error Description insufficient bytes transferred. Error Severity  Level=10

Error Type =809, Error Description Buffer 0x%lx, allocation page %S_PGID, in database '%.*ls' is not in allocation buffer pool in PSS (process status structure). Contact Technical Support.. Error Severity  Level=20

Error Type =813, Error Description Logical page %S_PGID in database ID %d is already hashed.. Error Severity  Level=20

Error Type =816, Error Description Process ID %d tried to remove a buffer resource lock %S_BUF that it does not hold in SDES %S_SDES. Contact Technical Support.. Error Severity  Level=20

Error Type =818, Error Description There is no room to hold the buffer resource lock %S_BUF in SDES %S_SDES. Contact Technical Support.. Error Severity  Level=19

Error Type =821, Error Description Could not unhash buffer at 0x%lx with a buffer page number of %S_PGID and database ID %d with HASHED status set. The buffer was not found. %S_PAGE.. Error Severity  Level=20

Error Type =822, Error Description Could not start I/O for request %S_BLKIOPTR.. Error Severity  Level=21

Error Type =823, Error Description I/O error %ls detected during %S_MSG at offset %#016I64x in file '%ls'.. Error Severity  Level=24

Error Type =824, Error Description SQL Server detected a logical consistency-based I/O error: %ls. It occurred during a %S_MSG of page %S_PGID in database ID %d at offset %#016I64x in file '%ls'. Additional messages in the SQL Server error log or system event log may provide more detail.. Error Severity  Level=24

Error Type =825, Error Description A read of the file '%ls' at offset %#016I64x succeeded after failing %d time(s) with error: %ls. Additional messages in the SQL Server error log and system event log may provide more detail. This error condition threatens database integrity and must be co. Error Severity  Level=10

Error Type =826, Error Description incorrect pageid (expected %d:%d; actual %d:%d). Error Severity  Level=10

Error Type =829, Error Description Database ID %d, Page %S_PGID is marked RestorePending, which may indicate disk corruption. To recover from this state, perform a restore.. Error Severity  Level=21

Error Type =830, Error Description stale page (a page read returned a log sequence number (LSN) (%u:%u:%u) that is older than the last one that was written (%u:%u:%u)). Error Severity  Level=10

Error Type =831, Error Description Unable to deallocate a kept page.. Error Severity  Level=20

Error Type =832, Error Description A page that should have been constant has changed (expected checksum: %08x, actual checksum: %08x, database %d, file '%ls', page %S_PGID). This usually indicates a memory failure or other hardware or OS corruption.. Error Severity  Level=24

Error Type =833, Error Description SQL Server has encountered %d occurrence(s) of I/O requests taking longer than %d seconds to complete on file [%ls] in database [%ls] (%d). The OS file handle is 0x%p. The offset of the latest long I/O is: %#016I64x. Error Severity  Level=10

Error Type =834, Error Description The bufclean system function was called on dirty buffer (page %S_PGID, stat %#x/%#x, objid %#x, sstat%#x).. Error Severity  Level=21

Error Type =840, Error Description Device '%.*ls' (physical name '%.*ls', virtual device number %d) is not available. Contact the system administrator for assistance.. Error Severity  Level=17

Error Type =844, Error Description Time out occurred while waiting for buffer latch type %d, bp %#x, page %S_PGID, stat %#x, object ID %d:%d:%d, waittime %d. Continuing to wait.. Error Severity  Level=10

Error Type =845, Error Description Time-out occurred while waiting for buffer latch type %d for page %S_PGID, database ID %d.. Error Severity  Level=17

Error Type =846, Error Description A time-out occurred while waiting for buffer latch -- type %d, bp %p, page %d:%d, stat %#x, database id: %d, allocation unit Id: %I64d%ls, task 0x%p : %d, waittime %d, flags 0x%I64x, owning task 0x%p. Not continuing to wait.. Error Severity  Level=10

Error Type =847, Error Description Timeout occurred while waiting for latch: class '%ls', id %p, type %d, Task 0x%p : %d, waittime %d, flags 0x%I64x, owning task 0x%p. Continuing to wait.. Error Severity  Level=10

Error Type =848, Error Description Using large pages for buffer pool.. Error Severity  Level=10

Error Type =849, Error Description Using locked pages for buffer pool.. Error Severity  Level=10

Error Type =850, Error Description %I64u MB of large page memory allocated.. Error Severity  Level=10

Error Type =851, Error Description the page is in an OFFLINE file which cannot be read. Error Severity  Level=10

Error Type =901, Error Description Could not find descriptor for database ID %d, object ID %ld in hash table after hashing it.. Error Severity  Level=21

Error Type =902, Error Description To change the %ls, the database must be in state in which a checkpoint can be executed.. Error Severity  Level=16

Error Type =903, Error Description Could not find row in sysindexes for clustered index on system catalog %ld in database ID %d. This index should exist in all databases. Run DBCC CHECKTABLE on sysindexes in the database.. Error Severity  Level=22

Error Type =904, Error Description Database %ld cannot be autostarted during server shutdown or startup.. Error Severity  Level=16

Error Type =905, Error Description Database '%.*ls' cannot be started in this edition of SQL Server because it contains a partition function '%.*ls'. Only Enterprise edition of SQL Server supports partitioning.. Error Severity  Level=21

Error Type =906, Error Description Could not locate row in sysobjects for system catalog '%.*ls' in database '%.*ls'. This system catalog should exist in all databases. Run DBCC CHECKTABLE on sysobjects in this database.. Error Severity  Level=22

Error Type =907, Error Description The database "%ls" has inconsistent database or file metadata.. Error Severity  Level=16

Error Type =908, Error Description Filegroup %ls in database %ls is unavailable because it is %ls. Restore or alter the filegroup to be available.. Error Severity  Level=10

Error Type =909, Error Description Database '%.*ls' cannot be started in this edition of SQL Server because part or all of object '%.*ls' is enabled with data compression or vardecimal storage format. Data compression and vardecimal storage format are only supported on SQL Server Enterpris. Error Severity  Level=21

Error Type =910, Error Description Database '%.*ls' is upgrading script '%.*ls' from level %d to level %d.. Error Severity  Level=10

Error Type =911, Error Description Could not locate entry in sysdatabases for database '%.*ls'. No entry found with that name. Make sure that the name is entered correctly.. Error Severity  Level=16

Error Type =912, Error Description Script level upgrade for database '%.*ls' failed because upgrade step '%.*ls' encountered error %d, state %d, severity %d. This is a serious error condition which might interfere with regular operation and the database will be taken offline. If the error. Error Severity  Level=21

Error Type =913, Error Description Could not find database ID %d. Database may not be activated yet or may be in transition.. Error Severity  Level=22

Error Type =914, Error Description Script level upgrade for database '%.*ls' failed because upgrade step '%.*ls' was aborted before completion. If the abort happened during upgrade of the 'master' database, it will prevent the entire SQL Server instance from starting. Examine the previous. Error Severity  Level=21

Error Type =915, Error Description Unable to obtain the current script level for database '%.*ls'. If the error happened during startup of the 'master' database, it will prevent the entire SQL Server instance from starting. Examine the previous errorlog entries for errors, take the approp. Error Severity  Level=21

Error Type =916, Error Description Server user '%.*ls' is not a valid user in database '%.*ls'.. Error Severity  Level=14

Error Type =917, Error Description An upgrade script batch failed to execute for database '%.*ls' due to compilation error. Check the previous error message for the line which caused compilation to fail.. Error Severity  Level=21

Error Type =918, Error Description Failed to load the engine script metadata from script DLL '%.*ls'. The error code reported by Windows was %d. This is a serious error condition, which usually indicates a corrupt or incomplete installation. Repairing the SQL Server instance may help resol. Error Severity  Level=21

Error Type =919, Error Description User '%.*ls' is changing database script level entry %d to a value of %d.. Error Severity  Level=10

Error Type =920, Error Description Only members of the sysadmin role can modify the database script level.. Error Severity  Level=20

Error Type =921, Error Description Database '%.*ls' has not been recovered yet. Wait and try again.. Error Severity  Level=14

Error Type =922, Error Description Database '%.*ls' is being recovered. Waiting until recovery is finished.. Error Severity  Level=14

Error Type =923, Error Description Database '%.*ls' is in restricted mode. Only the database owner and members of the dbcreator and sysadmin roles can access it.. Error Severity  Level=14

Error Type =924, Error Description Database '%.*ls' is already open and can only have one user at a time.. Error Severity  Level=14

Error Type =925, Error Description Maximum number of databases used for each query has been exceeded. The maximum allowed is %d.. Error Severity  Level=19

Error Type =926, Error Description Database '%.*ls' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.. Error Severity  Level=14

Error Type =927, Error Description Database '%.*ls' cannot be opened. It is in the middle of a restore.. Error Severity  Level=14

Error Type =928, Error Description During upgrade, database raised exception %d, severity %d, state %d, address %p. Use the exception number to determine the cause.. Error Severity  Level=20

Error Type =929, Error Description Attempting to close a database that is not already open. Contact Technical Support.. Error Severity  Level=20

Error Type =930, Error Description Attempting to reference recovery unit %d in database '%ls' which does not exist. Contact Technical Support.. Error Severity  Level=21

Error Type =931, Error Description Attempting to reference database fragment %d in database '%ls' which does not exist. Contact Technical Support.. Error Severity  Level=21

Error Type =932, Error Description SQL Server cannot load database '%.*ls' because change tracking is enabled. The currently installed edition of SQL Server does not support change tracking. Either disable change tracking in the database by using a supported edition of SQL Server, or upgra. Error Severity  Level=21

Error Type =933, Error Description Database '%.*ls' cannot be started because some of the database functionality is not available in the current edition of SQL Server.. Error Severity  Level=21

Error Type =934, Error Description SQL Server cannot load database '%.*ls' because Change Data Capture is enabled. The currently installed edition of SQL Server does not support Change Data Capture. Either disable Change Data Capture in the database by using a supported edition of SQL Serv. Error Severity  Level=21

Error Type =935, Error Description The script level for '%.*ls' in database '%.*ls' cannot be downgraded from %d to %d, which is supported by this server. This usually implies that a future database was attached and the downgrade path is not supported by the current installation. Install. Error Severity  Level=21

Error Type =941, Error Description Cannot open database '%.*ls'. It has not been upgraded to the latest format.. Error Severity  Level=14

Error Type =942, Error Description Database '%.*ls' cannot be opened because it is offline.. Error Severity  Level=14

Error Type =943, Error Description Database '%.*ls' cannot be opened because its version (%d) is later than the current server version (%d).. Error Severity  Level=14

Error Type =944, Error Description Converting database '%.*ls' from version %d to the current version %d.. Error Severity  Level=10

Error Type =945, Error Description Database '%.*ls' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.. Error Severity  Level=16

Error Type =946, Error Description Cannot open database '%.*ls' version %d. Upgrade the database to the latest version.. Error Severity  Level=14

Error Type =947, Error Description Error while closing database '%.*ls' cleanly.. Error Severity  Level=16

Error Type =948, Error Description Database '%.*ls' cannot be upgraded. Database is version %d and this server supports version %d.. Error Severity  Level=14

Error Type =949, Error Description tempdb is skipped. You cannot run a query that requires tempdb. Error Severity  Level=16

Error Type =950, Error Description Database '%.*ls' cannot be upgraded - database has a version (%d) earlier than SQL Server 7.0(%d).. Error Severity  Level=14

Error Type =951, Error Description Database '%.*ls' running the upgrade step from version %d to version %d.. Error Severity  Level=10

Error Type =952, Error Description Database '%.*ls' is in transition. Try the statement later.. Error Severity  Level=16

Error Type =953, Error Description Warning: Index '%ls' on '%ls' in database '%ls' may be corrupt because of expression evaluation changes in this release. Drop and re-create the index.. Error Severity  Level=16

Error Type =954, Error Description The database "%.*ls" cannot be opened. It is acting as a mirror database.. Error Severity  Level=14

Error Type =955, Error Description Database %.*ls is enabled for Database Mirroring, but the database lacks quorum: the database cannot be opened. Check the partner and witness connections if configured.. Error Severity  Level=14

Error Type =956, Error Description Database %.*ls is enabled for Database Mirroring, but has not yet synchronized with its partner. Try the operation again later.. Error Severity  Level=14

Error Type =957, Error Description Database '%.*ls' is enabled for Database Mirroring, The name of the database may not be changed.. Error Severity  Level=17

Error Type =958, Error Description The resource database build version is %.*ls. This is an informational message only. No user action is required.. Error Severity  Level=10

Error Type =959, Error Description The resource database version is %d and this server supports version %d. Restore the correct version or reinstall SQL Server.. Error Severity  Level=20

Error Type =960, Error Description Warning: User "sys" (principal_id = %d) in database "%.*ls" has been renamed to "%.*ls". "sys" is a reserved user or schema name in this version of SQL Server.. Error Severity  Level=10

Error Type =961, Error Description Warning: Index "%.*ls" (index_id = %d) on object ID %d in database "%.*ls" was renamed to "%.*ls" because its name is a duplicate of another index on the same object.. Error Severity  Level=10

Error Type =962, Error Description Warning: Primary key or Unique constraint "%.*ls" (object_id = %d) in database "%.*ls" was renamed to "%.*ls" because its index was renamed.. Error Severity  Level=10

Error Type =963, Error Description Warning: Database "%.*ls" was marked suspect because of actions taken during upgrade. See errorlog or eventlog for more information. Use ALTER DATABASE to bring the database online. The database will come online in restricted_user state.. Error Severity  Level=10

Error Type =964, Error Description Warning: System user '%.*ls' was found missing from database '%.*ls' and has been restored. This user is required for SQL Server operation.. Error Severity  Level=10

Error Type =965, Error Description Warning: A column nullability inconsistency was detected in the metadata of index "%.*ls" (index_id = %d) on object ID %d in database "%.*ls". The index may be corrupt. Run DBCC CHECKTABLE to verify consistency.. Error Severity  Level=10

Error Type =966, Error Description Warning: Assembly "%.*ls" in database "%.*ls" has been renamed to "%.*ls" because the name of the assembly conflicts with a system assembly in this version of SQL Server.. Error Severity  Level=10

Error Type =967, Error Description Warning: The index "%.*ls" on "%.*ls"."%.*ls" is disabled because the XML data bound to it may contain negative values for xs:date and xs:dateTime which are not longer supported.. Error Severity  Level=10

Error Type =968, Error Description Warning: The XML facet on type "%.*ls" in schema collection "%.*ls" is updated from "%.*ls" to "%.*ls" because Sql Server does not support negative years inside values of type xs:date or xs:dateTime.. Error Severity  Level=10

Error Type =969, Error Description Warning: The default or fixed value on XML element or attribute "%.*ls" in schema collection "%.*ls" is updated from "%.*ls" to "%.*ls" because Sql Server does not support negative years inside values of type xs:date or xs:dateTime.. Error Severity  Level=10

Error Type =970, Error Description Warning: The XML instances in the XML column "%.*ls.%.*ls.%.*ls" may contain negative simple type values of type xs:date or xs:dateTime. It will be impossible to run XQuery or build a primary XML index on these XML instances.. Error Severity  Level=10

Error Type =971, Error Description The resource database has been detected in two different locations. Attaching the resource database in the same directory as sqlservr.exe at '%.*ls' instead of the currently attached resource database at '%.*ls'.. Error Severity  Level=10

Error Type =972, Error Description Could not use database '%d' during procedure execution.. Error Severity  Level=17

Error Type =973, Error Description Database %ls was started . However, FILESTREAM is not compatible with the READ_COMMITTED_SNAPSHOT and ALLOW_SNAPSHOT_ISOLATION options. Either remove the FILESTREAM files and the FILESTREAM filegroups, or set READ_COMMITTED_SNAPSHOT and ALLOW_SNAPSHOT_. Error Severity  Level=10