Thursday, 15 August 2013

SQL Server - 'Error messages' list 3000 to 4000

SQL Server error messages list 3000 to 4000



error
severity
description
3002
16
Cannot BACKUP or RESTORE a database snapshot.
3003
10
This BACKUP WITH DIFFERENTIAL will be based on more than one file backup. All those file backups must be restored before attempting to restore this differential backup.
3004
16
The primary filegroup cannot be backed up as a file backup because the database is using the SIMPLE recovery model. Consider taking a partial backup by specifying READ_WRITE_FILEGROUPS.
3005
10
The differential partial backup is including a read-only filegroup, ‘%ls’. This filegroup was read-write when the base partial backup was created, but was later changed to read-only access. We recommend that you create a separate file backup of the ‘%ls’
3006
16
The differential backup is not allowed because it would be based on more than one base backup. Multi-based differential backups are not allowed in the simple recovery model, and are never allowed for partial differential backups.
3007
16
The backup of the file or filegroup “%ls” is not permitted because it is not online. Container state: “%ls” (%d). Restore status: %d. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data.
3008
16
The specified device type is not supported for backup mirroring.
3009
16
Could not insert a backup or restore history/detail record in the msdb database. This may indicate a problem with the msdb database. The backup/restore operation was still successful.
3010
16
Invalid backup mirror specification. All mirrors must have the same number of members.
3011
16
All backup devices must be of the same general class (for example, DISK and TAPE).
3012
17
VDI ran out of buffer when SQL Server attempted to send differential information to SQL Writer.
3013
16
%hs is terminating abnormally.
3014
10
%hs successfully processed %I64d pages in %d.%03d seconds (%d.%03d MB/sec).
3015
10
%hs is not yet implemented.
3016
16
Backup of file ‘%ls’ is not permitted because it contains pages subject to an online restore sequence. Complete the restore sequence before taking the backup, or restrict the backup to exclude this file.
3017
16
The restart-checkpoint file ‘%ls’ could not be opened. Operating system error ‘%ls’. Correct the problem, or reissue the command without RESTART.
3018
10
The restart-checkpoint file ‘%ls’ was not found. The RESTORE command will continue from the beginning as if RESTART had not been specified.
3019
16
The restart-checkpoint file ‘%ls’ is from a previous interrupted RESTORE operation and is inconsistent with the current RESTORE command. The restart command must use the same syntax as the interrupted command, with the addition of the RESTART clause. Alte
3021
16
Cannot perform a backup or restore operation within a transaction.
3022
10
This backup is a file backup of read-write data from a database that uses the simple recovery model. This is only appropriate if you plan to set the filegroup to read-only followed by a differential file backup. Consult Books Online for more information o
3023
16
Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed.
3024
16
You can only perform a full backup of the master database. Use BACKUP DATABASE to back up the entire master database.
3025
16
Missing database name. Reissue the statement specifying a valid database name.
3027
16
The filegroup “%.*ls” is not part of database “%.*ls”.
3028
10
The restart-checkpoint file ‘%ls’ was corrupted and is being ignored. The RESTORE command will continue from the beginning as if RESTART had not been specified.
3031
16
Option ‘%ls’ conflicts with option(s) ‘%ls’. Remove the conflicting option and reissue the statement.
3032
16
One or more of the options (%ls) are not supported for this statement. Review the documentation for supported options.
3033
16
BACKUP DATABASE cannot be used on a database opened in emergency mode.
3034
16
No files were selected to be processed. You may have selected one or more filegroups that have no members.
3035
16
Cannot perform a differential backup for database “%ls”, because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option.
3036
16
The database “%ls” is in warm-standby state (set by executing RESTORE WITH STANDBY) and cannot be backed up until the entire restore sequence is completed.
3038
16
The file name “%ls” is invalid as a backup device name. Reissue the BACKUP statement with a valid file name.
3039
16
Cannot perform a differential backup for file ‘%ls’ because a current file backup does not exist. Reissue BACKUP DATABASE omitting the WITH DIFFERENTIAL option.
3040
10
An error occurred while informing replication of the backup. The backup will continue, but the replication environment should be inspected.
3041
16
BACKUP failed to complete the command %.*ls. Check the backup application log for detailed messages.
3042
10
BACKUP WITH CONTINUE_AFTER_ERROR successfully generated a backup of the damaged database. Refer to the SQL Server error log for information about the errors that were encountered.
3043
16
BACKUP ‘%ls’ detected an error on page (%d:%d) in file ‘%ls’.
3044
16
Invalid zero-length device name. Reissue the BACKUP statement with a valid device name.
3045
16
BACKUP or RESTORE requires the NTFS file system for FILESTREAM and full-text support. The path “%.*ls” is not usable.
3046
16
Inconsistent metadata has been encountered. The only possible backup operation is a tail-log backup using the WITH CONTINUE_AFTER_ERROR or NO_TRUNCATE option.
3047
16
The BackupDirectory registry key is not configured correctly. This key should specify the root path where disk backup files are stored when full path names are not provided. This path is also used to locate restart checkpoint files for RESTORE.
3049
16
BACKUP detected corruption in the database log. Check the errorlog for more information.
3050
16
SQL Server could not send the differential information for database file ‘%ls’ of database ‘%ls\\%ls’ to the backup application because the differential information is too large to fit in memory, and an attempt to use a temporary file has failed.
3051
16
BACKUP LOG was unable to maintain mirroring consistency for database ‘%ls’. Database mirroring has been suspended.
3054
16
Differential file backups can include only read-only data for databases using the simple recovery model. Consider taking a partial backup by specifying READ_WRITE_FILEGROUPS.
3055
16
Backup destination “%.*ls” supports a FILESTREAM filegroup. This filegroup cannot be used as a backup destination. Rerun the BACKUP statement with a valid backup destination.
3056
16
The backup operation has detected an unexpected file in a FILESTREAM container. The backup operation will continue and include file ‘%ls’.
3057
16
Invalid device name. The length of the device name provided exceeds supported limit (maximum length is:%d). Reissue the BACKUP statement with a valid device name.
3058
10
File or device name exceeds the supported limit (maximum length is:%d) and will be truncated: %.*ls.
3098
16
The backup cannot be performed because ‘%ls’ was requested after the media was formatted with an incompatible structure. To append to this media set, either omit ‘%ls’ or specify ‘%ls’. Alternatively, you can create a new media set by using WITH FORMAT in
3101
16
Exclusive access could not be obtained because the database is in use.
3102
16
%ls cannot process database ‘%ls’ because it is in use by this session. It is recommended that the master database be used when performing this operation.
3103
16
A partial restore sequence cannot be initiated by this command. To initiate a partial restore sequence, use the WITH PARTIAL clause of the RESTORE statement and provide a backup set which includes a full copy of at least the primary data file. The WITH PA
3104
16
RESTORE cannot operate on database ‘%ls’ because it is configured for database mirroring. Use ALTER DATABASE to remove mirroring if you intend to restore the database.
3105
16
RESTORE cannot restore any more pages into file ‘%ls’ because the maximum number of pages (%d) are already being restored. Either complete the restore sequence for the existing pages, or use RESTORE FILE to restore all pages in the file.
3106
16
The filegroup “%ls” is ambiguous. The identity in the backup set does not match the filegroup that is currently defined in the online database. To force the use of the filegroup in the backup set, take the database offline and then reissue the RESTORE com
3107
16
The file “%ls” is ambiguous. The identity in the backup set does not match the file that is currently defined in the online database. To force the use of the file in the backup set, take the database offline and then reissue the RESTORE command.
3108
16
To restore the master database, the server must be running in single-user mode. For information on starting in single-user mode, see “How to: Start an Instance of SQL Server (sqlservr.exe)” in Books Online.
3109
16
Master can only be restored and fully recovered in a single step using a full database backup. Options such as NORECOVERY, STANDBY, and STOPAT are not supported.
3110
14
User does not have permission to RESTORE database ‘%.*ls’.
3111
16
Page %S_PGID is a control page which cannot be restored in isolation. To repair this page, the entire file must be restored.
3112
16
Cannot restore any database other than master when the server is in single user mode.
3113
16
Invalid data was detected.
3115
16
The database is using the simple recovery model. It is not possible to restore a subset of the read-write data.
3116
16
The supplied backup is not on the same recovery path as the database, and is ineligible for use for an online file restore.
3117
16
The log or differential backup cannot be restored because no files are ready to rollforward.
3118
16
The database “%ls” does not exist. RESTORE can only create a database when restoring either a full backup or a file backup of the primary file.
3119
16
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
3120
16
This backup set will not be restored because all data has already been restored to a point beyond the time covered by this backup set.
3121
16
The file “%ls” is on a recovery path that is inconsistent with application of this backup set. RESTORE cannot continue.
3122
16
File initialization failed. RESTORE cannot continue.
3123
16
Invalid database name ‘%.*ls’ specified for backup or restore operation.
3125
16
The database is using the simple recovery model. The data in the backup it is not consistent with the current state of the database. Restoring more data is required before recovery is possible. Either restore a full file backup taken since the data was ma
3127
16
The file ‘%.*ls’ of restored database ‘%ls’ is being left in the defunct state because the database is using the simple recovery model and the file is marked for read-write access. Therefore, only read-only files can be recovered by piecemeal restore.
3128
16
File ‘%ls’ has an unsupported page size (%d).
3129
16
The contents of the file “%ls” are not consistent with a transition into the restore sequence. A restore from a backup set may be required.
3130
10
The filegroup “%ls” is selected. At the time of backup it was known by the name “%ls”‘. RESTORE will continue operating upon the renamed filegroup.
3131
10
The file “%ls” is selected. At the time of backup it was known by the name “%ls”. RESTORE will continue operating upon the renamed file.
3132
16
The media set has %d media families but only %d are provided. All members must be provided.
3133
16
The volume on device “%ls” is sequence number %d of media family %d, but sequence number %d of media family %d is expected. Check that the device specifications and loaded media are correct.
3134
10
The differential base attribute for file ‘%ls’ of database ‘%ls’ has been reset because the file has been restored from a backup taken on a conflicting recovery path. The restore was allowed because the file was read-only and was consistent with the curre
3135
16
The backup set in file ‘%ls’ was created by %hs and cannot be used for this restore operation.
3136
16
This differential backup cannot be restored because the database has not been restored to the correct earlier state.
3137
16
Database cannot be reverted. Either the primary or the snapshot names are improperly specified, all other snapshots have not been dropped, or there are missing files.
3138
16
The database cannot be reverted because FILESTREAM BLOBs are present.
3139
16
Restore to snapshot is not allowed with the master database.
3140
16
Could not adjust the space allocation for file ‘%ls’.
3141
16
The database to be restored was named ‘%ls’. Reissue the statement using the WITH REPLACE option to overwrite the ‘%ls’ database.
3142
16
File “%ls” cannot be restored over the existing “%ls”. Reissue the RESTORE statement using WITH REPLACE to overwrite pre-existing files, or WITH MOVE to identify an alternate location.
3143
16
The data set on device ‘%ls’ is not a SQL Server backup set.
3144
16
File ‘%.*ls’ was not backed up in file %d on device ‘%ls’. The file cannot be restored from this backup set.
3145
16
The STOPAT option is not supported for databases that use the SIMPLE recovery model.
3147
16
Backup and restore operations are not allowed on database tempdb.
3148
16
This RESTORE statement is invalid in the current context. The ‘Recover Data Only’ option is only defined for secondary filegroups when the database is in an online state. When the database is in an offline state filegroups cannot be specified.
3149
16
The file or filegroup “%ls” is not in a valid state for the “Recover Data Only” option to be used. Only secondary files in the OFFLINE or RECOVERY_PENDING state can be processed.
3150
10
The master database has been successfully restored. Shutting down SQL Server.
3151
21
Failed to restore master database. Shutting down SQL Server. Check the error logs, and rebuild the master database. For more information about how to rebuild the master database, see SQL Server Books Online.
3153
16
The database is already fully recovered.
3154
16
The backup set holds a backup of a database other than the existing ‘%ls’ database.
3155
16
The RESTORE operation cannot proceed because one or more files have been added or dropped from the database since the backup set was created.
3156
16
File ‘%ls’ cannot be restored to ‘%ls’. Use WITH MOVE to identify a valid location for the file.
3159
16
The tail of the log for the database “%ls” has not been backed up. Use BACKUP LOG WITH NORECOVERY to backup the log if it contains work you do not want to lose. Use the WITH REPLACE or WITH STOPAT clause of the RESTORE statement to just overwrite the cont
3161
16
The primary file is unavailable. It must be restored or otherwise made available.
3163
16
The transaction log was damaged. All data files must be restored before RESTORE LOG can be attempted.
3165
16
Database ‘%ls’ was restored, however an error was encountered while replication was being restored/removed. The database has been left offline. See the topic MSSQL_ENG003165 in SQL Server Books Online.
3166
16
RESTORE DATABASE could not drop database ‘%ls’. Drop the database and then reissue the RESTORE DATABASE statement.
3167
16
RESTORE could not start database ‘%ls’.
3168
16
The backup of the system database on the device %ls cannot be restored because it was created by a different version of the server (%ls) than this server (%ls).
3169
16
The database was backed up on a server running version %ls. That version is incompatible with this server, which is running version %ls. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.
3170
16
The STANDBY filename is invalid.
3171
16
File %ls is defunct and cannot be restored into the online database.
3172
16
Filegroup %ls is defunct and cannot be restored into the online database.
3173
16
The STOPAT clause provided with this RESTORE statement indicates that the tail of the log contains changes that must be backed up to reach the target point in time. The tail of the log for the database “%ls” has not been backed up. Use BACKUP LOG WITH NOR
3174
16
The file ‘%ls’ cannot be moved by this RESTORE operation.
3175
10
RESTORE FILEGROUP=”%ls” was specified, but not all of its files are present in the backup set. File “%ls” is missing. RESTORE will continue, but if you want all files to be restored, you must restore other backup sets.
3176
16
File ‘%ls’ is claimed by ‘%ls’(%d) and ‘%ls’(%d). The WITH MOVE clause can be used to relocate one or more files.
3178
16
File %ls is not in the correct state to have this differential backup applied to it.
3179
16
The system database cannot be moved by RESTORE.
3180
16
This backup cannot be restored using WITH STANDBY because a database upgrade is needed. Reissue the RESTORE without WITH STANDBY.
3181
10
Attempting to restore this backup may encounter storage space problems. Subsequent messages will provide details.
3182
16
The backup set cannot be restored because the database was damaged when the backup occurred. Salvage attempts may exploit WITH CONTINUE_AFTER_ERROR.
3183
16
RESTORE detected an error on page (%d:%d) in database “%ls” as read from the backup set.
3184
10
RESTORE WITH CONTINUE_AFTER_ERROR was successful but some damage was encountered. Inconsistencies in the database are possible.
3185
16
RESTORE cannot apply this backup set because the database is suspect. Restore a backup set that repairs the damage.
3186
16
The backup set has been damaged. RESTORE will not attempt to apply this backup set.
3187
16
RESTORE WITH CHECKSUM cannot be specified because the backup set does not contain checksum information.
3188
10
The backup set was written with damaged data by a BACKUP WITH CONTINUE_AFTER_ERROR.
3189
16
Damage to the backup set was detected.
3190
16
Filegroup ‘%ls’ cannot be restored because it does not exist in the backup set.
3191
16
Restore cannot continue because file ‘%ls’ cannot be written. Ensure that all files in the database are writable.
3192
10
Restore was successful but deferred transactions remain. These transactions cannot be resolved because there are data that is unavailable. Either use RESTORE to make that data available or drop the filegroups if you never need this data again. Dropping th
3194
16
Page %S_PGID is beyond the end of the file. Only pages that are in the current range of the file can be restored.
3195
16
Page %S_PGID cannot be restored from this backup set. RESTORE PAGE can only be used from full backup sets or from the first log or differential backup taken since the file was added to the database.
3196
16
RESTORE master WITH SNAPSHOT is not supported. To restore master from a snapshot backup, stop the service and copy the data and log file.
3197
10
I/O is frozen on database %ls. No user action is required. However, if I/O is not resumed promptly, you could cancel the backup.
3198
10
I/O was resumed on database %ls. No user action is required.
3199
16
RESTORE requires MAXTRANSFERSIZE=%u but %u was specified.
3201
16
Cannot open backup device ‘%ls’. Operating system error %ls.
3202
16
Write on “%ls” failed: %ls
3203
16
Read on “%ls” failed: %ls
3204
16
The backup or restore was aborted.
3205
16
Too many backup devices specified for backup or restore; only %d are allowed.
3206
16
Backup device ‘%.*ls’ does not exist. To view existing backup devices, use the sys.backup_devices catalog view. To create a new backup device use either sp_addumpdevice or SQL Server Management Studio.
3207
16
Backup or restore requires at least one backup device. Rerun your statement specifying a backup device.
3208
16
Unexpected end of file while reading beginning of backup set. Confirm that the media contains a valid SQL Server backup set, and see the console error log for more details.
3209
16
Operation is not supported on user instances.
3210
16
The mirror member in drive “%ls” is inconsistent with the mirror member in drive “%ls”.
3211
10
%d percent processed.
3212
16
The mirror device “%ls” and the mirror device “%ls” have different device specifications.
3213
16
Unable to unload one or more tapes. See the error log for details.
3214
16
Too many backup mirrors are specified. Only %d are allowed.
3215
16
Use WITH FORMAT to create a new mirrored backup set.
3216
16
RESTORE REWINDONLY is only applicable to tape devices.
3217
16
Invalid value specified for %ls parameter.
3218
16
Backup mirroring is not available in this edition of SQL Server. See Books Online for more details on feature support in different SQL Server editions.
3219
16
The file or filegroup “%.*ls” cannot be selected for this operation.
3221
16
The ReadFileEx system function executed on file ‘%ls’ only read %d bytes, expected %d.
3222
16
The WriteFileEx system function executed on file ‘%ls’ only wrote %d bytes, expected %d.
3224
16
Cannot create worker thread.
3227
16
The backup media on “%ls” is part of media family %d which has already been processed on “%ls”. Ensure that backup devices are correctly specified. For tape devices, ensure that the correct volumes are loaded.
3229
16
Request for device ‘%ls’ timed out.
3230
16
Operation on device ‘%ls’ exceeded retry count.
3231
16
The media loaded on “%ls” is formatted to support %d media families, but %d media families are expected according to the backup device specification.
3232
16
The volume mounted on “%ls” does not have the expected backup set identity. The volume may be obsolete due to a more recent overwrite of this media family. In that case, locate the correct volume with sequence number %d of media family %d.
3234
16
Logical file ‘%.*ls’ is not part of database ‘%ls’. Use RESTORE FILELISTONLY to list the logical file names.
3235
16
The file “%.*ls” is not part of database “%ls”. You can only list files that are members of this database.
3239
16
The backup set on device ‘%ls’ uses a feature of the Microsoft Tape Format not supported by SQL Server.
3240
16
Backup to mirrored media sets requires all mirrors to append. Provide all members of the set, or reformat a new media set.
3241
16
The media family on device ‘%ls’ is incorrectly formed. SQL Server cannot process this media family.
3242
16
The file on device ‘%ls’ is not a valid Microsoft Tape Format backup set.
3243
16
The media family on device ‘%ls’ was created using Microsoft Tape Format version %d.%d. SQL Server supports version %d.%d.
3244
16
Descriptor block size exceeds %d bytes. Use a shorter name and/or description string and retry the operation.
3245
16
Could not convert a string to or from Unicode, %ls.
3246
16
The media family on device ‘%ls’ is marked as nonappendable. Reissue the statement using the INIT option to overwrite the media.
3247
16
The volume on device ‘%ls’ has the wrong media sequence number (%d). Remove it and insert volume %d.
3249
16
The volume on device ‘%ls’ is a continuation volume for the backup set. Remove it and insert the volume holding the start of the backup set.
3250
16
The value ‘%d’ is not within range for the %ls parameter.
3251
10
The media family on device ‘%ls’ is complete. The device is now being reused for one of the remaining families.
3253
16
The block size parameter must supply a value that is a power of 2.
3254
16
The volume on device ‘%ls’ is empty.
3255
16
The data set on device ‘%ls’ is a SQL Server backup set not compatible with this version of SQL Server.
3256
16
The backup set on device ‘%ls’ was terminated while it was being created and is incomplete. RESTORE sequence is terminated abnormally.
3257
16
There is insufficient free space on disk volume ‘%ls’ to create the database. The database requires %I64u additional free bytes, while only %I64u bytes are available.
3258
16
The volume on the device “%ls” is not part of the media set that is currently being processed. Ensure that the backup devices are loaded with the correct media.
3260
16
An internal buffer has become full.
3261
16
SQL Server cannot use the virtual device configuration.
3262
10
The backup set on file %d is valid.
3263
16
Cannot use the volume on device ‘%ls’ as a continuation volume. It is sequence number %d of family %d for the current media set. Insert a new volume, or sequence number %d of family %d for the current set.
3264
16
The operation did not proceed far enough to allow RESTART. Reissue the statement without the RESTART qualifier.
3265
16
The login has insufficient authority. Membership of the sysadmin role is required to use VIRTUAL_DEVICE with BACKUP or RESTORE.
3266
16
The backup data at the end of “%ls” is incorrectly formatted. Backup sets on the media might be damaged and unusable. To determine the backup sets on the media, use RESTORE HEADERONLY. To determine the usability of the backup sets, run RESTORE VERIFYONLY.
3267
16
Insufficient resources to create UMS scheduler.
3268
16
Cannot use the backup file ‘%ls’ because it was originally formatted with sector size %d and is now on a device with sector size %d.
3269
16
Cannot restore the file ‘%ls’ because it was originally written with sector size %d; ‘%ls’ is now on a device with sector size %d.
3270
16
An internal consistency error has occurred. This error is similar to an assert. Contact technical support for assistance.
3271
16
A nonrecoverable I/O error occurred on file “%ls:” %ls.
3272
16
The ‘%ls’ device has a hardware sector size of %d, but the block size parameter specifies an incompatible override value of %d. Reissue the statement using a compatible block size.
3276
16
WITH SNAPSHOT can be used only if the backup set was created WITH SNAPSHOT.
3277
16
WITH SNAPSHOT must be used with only one virtual device.
3278
16
Failed to encrypt string %ls
3279
16
Access is denied due to a password failure
3280
16
Backups on raw devices are not supported. ‘%ls’ is a raw device.
3281
10
Released and initiated rewind on ‘%ls’.
3283
16
The file “%ls” failed to initialize correctly. Examine the error logs for more details.
3284
16
Filemark on device ‘%ls’ is not aligned. Re-issue the Restore statement with the same blocksize used to create the backupset: ‘%d’ looks like a possible value.
3301
21
The transaction log contains a record (logop %d) that is not valid. The log has been corrupted. Restore the database from a full backup, or repair the database.
3302
21
Redoing of logged operations in database ‘%.*ls’ failed to reach end of log at log record ID %S_LSN. This indicates corruption around log record ID %S_LSN. Restore the database from a full backup, or repair the database.
3313
21
During redoing of a logged operation in database ‘%.*ls’, an error occurred at log record ID %S_LSN. Typically, the specific failure is previously logged as an error in the Windows Event Log service. Restore the database from a full backup, or repair the
3314
21
During undoing of a logged operation in database ‘%.*ls’, an error occurred at log record ID %S_LSN. Typically, the specific failure is logged previously as an error in the Windows Event Log service. Restore the database or file from a backup, or repair t
3315
21
During rollback, the following process did not hold an expected lock: process %d with mode %d at level %d for row %S_RID in database ‘%.*ls’ under transaction %S_XID. Restore a backup of the database, or repair the database.
3316
21
During undo of a logged operation in database ‘%.*ls’, an error occurred at log record ID %S_LSN. The row was not found. Restore the database from a full backup, or repair the database.
3401
10
Errors occurred during recovery while rolling back a transaction. The transaction was deferred. Restore the bad page or file, and re-run recovery.
3402
10
The database ‘%ls’ is marked %ls and is in a state that does not allow recovery to be run.
3403
10
Recovering only master database because traceflag 3608 was specified. This is an informational message only. No user action is required.
3404
10
Failed to check for new installation or a renamed server at startup. The logic for this check has failed unexpectedly. Run setup again, or fix the problematic registry key.
3406
10
%d transactions rolled forward in database ‘%.*ls’ (%d). This is an informational message only. No user action is required.
3407
10
%d transactions rolled back in database ‘%.*ls’ (%d). This is an informational message only. No user action is required.
3408
10
Recovery is complete. This is an informational message only. No user action is required.
3409
16
Performance counter shared memory setup failed with error %d. Reinstall sqlctr.ini for this instance, and ensure that the instance login account has correct registry permissions.
3410
10
Data in filegroup %s is offline, and deferred transactions exist. Use RESTORE to recover the filegroup, or drop the filegroup if you never intend to recover it. Log truncation cannot occur until this condition is resolved.
3411
21
Configuration block version %d is not a valid version number. SQL Server is exiting. Restore the master database or reinstall.
3412
10
Warning: The server instance was started using minimal configuration startup option (-f). Starting an instance of SQL Server with minimal configuration places the server in single-user mode automatically. After the server has been started with minimal co
3413
21
Database ID %d. Could not mark database as suspect. Getnext NC scan on sys.databases.database_id failed. Refer to previous errors in the error log to identify the cause and correct any associated problems.
3414
10
An error occurred during recovery, preventing the database ‘%.*ls’ (database ID %d) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.
3415
16
Database ‘%.*ls’ cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery.
3416
16
The server contains read-only files that must be made writable before the server can be recollated.
3417
21
Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. For more information about how to rebuild the master database, see SQL Server Books Online.
3418
10
Recovery is unable to defer error %d. Errors can only be deferred in databases using the full recovery model and an active backup log chain.
3419
16
Recovery for database ‘%.*ls’ is being skipped because it requires an upgrade but is marked for Standby. Use RESTORE DATABASE WITH NORECOVERY to take the database back to a Restoring state and continue the restore sequence.
3420
21
Database snapshot ‘%ls’ has failed an IO operation and is marked suspect. It must be dropped and recreated.
3421
10
Recovery completed for database %ls (database ID %d) in %I64d second(s) (analysis %I64d ms, redo %I64d ms, undo %I64d ms.) This is an informational message only. No user action is required.
3422
10
Database %ls was shutdown due to error %d in routine ‘%hs’. Restart for non-snapshot databases will be attempted after all connections to the database are aborted.
3429
10
Recovery could not determine the outcome of a cross-database transaction %S_XID, named ‘%.*ls’, in database ‘%.*ls’ (database ID %d). The coordinating database (database ID %d) was unavailable. The transaction was assumed to be committed. If the transacti
3431
21
Could not recover database ‘%.*ls’ (database ID %d) because of unresolved transaction outcomes. Microsoft Distributed Transaction Coordinator (MS DTC) transactions were prepared, but MS DTC was unable to determine the resolution. To resolve, either fix MS
3434
20
Cannot change sort order or locale. An unexpected failure occurred while trying to reindex the server to a new collation. SQL Server is shutting down. Restart SQL Server to continue with the sort order unchanged. Diagnose and correct previous errors and t
3437
21
An error occurred while recovering database ‘%.*ls’. Unable to connect to Microsoft Distributed Transaction Coordinator (MS DTC) to check the completion status of transaction %S_XID. Fix MS DTC, and run recovery again.
3441
21
During startup of warm standby database ‘%.*ls’ (database ID %d), its standby file (‘%ls’) was inaccessible to the RESTORE statement. The operating system error was ‘%ls’. Diagnose the operating system error, correct the problem, and retry startup.
3442
21
Recovery of warm standby database ‘%.*ls’ (database ID %d) failed. There is insufficient room in the undo file. Increase the size of the undo file and retry recovery.
3443
21
Database ‘%.*ls’ (database ID %d) was marked for standby or read-only use, but has been modified. The RESTORE LOG statement cannot be performed. Restore the database from a backup.
3445
21
File ‘%ls’ is not a valid undo file for database ‘%.*ls (database ID %d). Verify the file path, and specify the correct file.
3446
16
Primary log file is not available for database ‘%.*ls’. The log cannot be backed up.
3447
16
Could not activate or scan all of the log files for database ‘%.*ls’.
3448
21
Rollback encountered a page with a log sequence number (LSN) less than the original log record LSN. Could not undo log record %S_LSN, for transaction ID %S_XID, on page %S_PGID, database ‘%.*ls’ (database ID %d). Page information: LSN = %S_LSN, type = %ld
3449
21
SQL Server must shut down in order to recover a database (database ID %d). The database is either a user database that could not be shut down or a system database. Restart SQL Server. If the database fails to recover after another startup, repair or resto
3450
10
Recovery of database ‘%.*ls’ (%d) is %d%% complete (approximately %d seconds remain). Phase %d of 3. This is an informational message only. No user action is required.
3452
10
Recovery of database ‘%.*ls’ (%d) detected possible identity value inconsistency in table ID %d. Run DBCC CHECKIDENT (‘%.*ls’).
3453
16
This version cannot redo any index creation or non-logged operation done by SQL Server 7.0. Further roll forward is not possible.
3454
10
Recovery is writing a checkpoint in database ‘%.*ls’ (%d). This is an informational message only. No user action is required.
3456
21
Could not redo log record %S_LSN, for transaction ID %S_XID, on page %S_PGID, database ‘%.*ls’ (database ID %d). Page: LSN = %S_LSN, type = %ld. Log: OpCode = %ld, context %ld, PrevPageLSN: %S_LSN. Restore from a backup of the database, or repair the data
3457
21
Transactional file system resource manager ‘%.*ls’ failed to recover. For more information, see the accompanying error message, which determines the appropriate user action.
3458
16
Recovery cannot scan database “%.*ls” for dropped allocation units because an unexpected error has occurred. These allocation units cannot be cleaned up.
3505
14
Only the owner of database “%.*ls” or someone with relevant permissions can run the CHECKPOINT statement.
3604
10
Duplicate key was ignored.
3605
16
Schema verification failed for database ‘%.*ls’.
3606
10
Arithmetic overflow occurred.
3607
10
Division by zero occurred.
3608
16
Cannot allocate a GUID for the token.
3609
16
The transaction ended in the trigger. The batch has been aborted.
3612
10
%hs SQL Server Execution Times:%hs CPU time = %lu ms, elapsed time = %lu ms.
3613
10
SQL Server parse and compile time: %hs CPU time = %lu ms, elapsed time = %lu ms.
3615
10
Table ‘%.*ls’. Scan count %d, logical reads %d, physical reads %d, read-ahead reads %d, lob logical reads %d, lob physical reads %d, lob read-ahead reads %d.
3616
16
An error was raised during trigger execution. The batch has been aborted and the user transaction, if any, has been rolled back.
3619
10
Could not write a checkpoint record in database ID %d because the log is out of space. Contact the database administrator to truncate the log or allocate more space to the database log files.
3620
10
Automatic checkpointing is disabled in database ‘%.*ls’ because the log is out of space. Automatic checkpointing will be enabled when the database owner successfully checkpoints the database. Contact the database owner to either truncate the log file or a
3621
10
The statement has been terminated.
3622
10
Warning: An invalid floating point operation occurred.
3623
16
An invalid floating point operation occurred.
3624
20
A system assertion check has failed. Check the SQL Server error log for details. Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB. If you agreed to send dumps t
3625
20
‘%hs’ is not yet implemented.
3627
17
New parallel operation cannot be started due to too many parallel operations executing at this time. Use the “max worker threads” configuration option to increase the number of allowable threads, or reduce the number of parallel operations running on the
3628
24
The Database Engine received a floating point exception from the operating system while processing a user request. Try the transaction again. If the problem persists, contact your system administrator.
3633
16
The operating system returned the error ‘%ls’ while attempting ‘%ls’ on ‘%ls’ at ‘%hs’(%d).
3634
16
The operating system returned the error ‘%ls’ while attempting ‘%ls’ on ‘%ls’.
3635
16
An error occurred while processing ‘%ls’ metadata for database id %d, file id %d, and transaction=’%.*ls’. Additional Context=’%ls’. Location=’%hs’(%d). Retry the operation; if the problem persists, contact the database administrator to review locking and
3636
16
An error occurred while processing ‘%ls’ metadata for database id %d file id %d.
3637
16
A parallel operation cannot be started from a DAC connection.
3638
10
SQL text cache memory usage: %d pages. This is an informational message only; no user action is required.
3639
16
This operation is not supported on a single-file DB.
3701
11
Cannot %S_MSG the %S_MSG ‘%.*ls’, because it does not exist or you do not have permission.
3702
16
Cannot drop database “%.*ls” because it is currently in use.
3703
16
Cannot detach the %S_MSG ‘%.*ls’ because it is currently in use.
3705
16
Cannot use DROP %ls with ‘%.*ls’ because ‘%.*ls’ is a %S_MSG. Use %ls.
3706
16
Cannot %S_MSG a database snapshot.
3707
16
Cannot detach a suspect or recovery pending database. It must be repaired or dropped.
3708
16
Cannot %S_MSG the %S_MSG ‘%.*ls’ because it is a system %S_MSG.
3709
16
Cannot %S_MSG the database while the database snapshot “%.*ls” refers to it. Drop that database first.
3710
16
Cannot detach an opened database when the server is in minimally configured mode.
3716
16
The %S_MSG ‘%.*ls’ cannot be dropped because it is bound to one or more %S_MSG.
3717
16
Cannot drop a default constraint by DROP DEFAULT statement. Use ALTER TABLE to drop a constraint default.
3721
16
Type ‘%.*ls’ cannot be renamed because it is being referenced by object ‘%.*ls’.
3723
16
An explicit DROP INDEX is not allowed on index ‘%.*ls’. It is being used for %ls constraint enforcement.
3724
16
Cannot %S_MSG the %S_MSG ‘%.*ls’ because it is being used for replication.
3725
16
The constraint ‘%.*ls’ is being referenced by table ‘%.*ls’, foreign key constraint ‘%.*ls’.
3726
16
Could not drop object ‘%.*ls’ because it is referenced by a FOREIGN KEY constraint.
3727
10
Could not drop constraint. See previous errors.
3728
16
‘%.*ls’ is not a constraint.
3729
16
Cannot %ls ‘%.*ls’ because it is being referenced by object ‘%.*ls’.
3730
16
Cannot drop the default constraint ‘%.*ls’ while it is being used by a foreign key as SET DEFAULT referential action.
3732
16
Cannot drop type ‘%.*ls’ because it is being referenced by object ‘%.*ls’. There may be other objects that reference this type.
3733
16
Constraint ‘%.*ls’ does not belong to table ‘%.*ls’.
3734
16
Could not drop the primary key constraint ‘%.*ls’ because the table has an XML or spatial index.
3735
16
The primary key constraint ‘%.*ls’ on table ‘%.*ls’ cannot be dropped because change tracking is enabled on the table. Change tracking requires a primary key constraint on the table. Disable change tracking before dropping the constraint.
3737
16
Could not delete file ‘%ls’. See the SQL Server error log for more information.
3738
10
Deleting database file ‘%ls’.
3739
11
Cannot %ls the index ‘%.*ls’ because it is not a statistics collection.
3740
16
Cannot drop the %S_MSG ‘%.*ls’ because at least part of the table resides on a read-only filegroup.
3741
16
Cannot drop the %S_MSG ‘%.*ls’ because at least part of the table resides on an offline filegroup.
3743
16
The database ‘%.*ls’ is enabled for database mirroring. Database mirroring must be removed before you drop the database.
3744
16
Only a single clause is allowed in a statement where an index is dropped online.
3745
16
Only a clustered index can be dropped online.
3746
16
Cannot drop the clustered index of view ‘%.*ls’ because the view is being used for replication.
3747
16
Cannot drop a clustered index created on a view using drop clustered index clause. Clustered index ‘%.*ls’ is created on view ‘%.*ls’.
3748
16
Cannot drop non-clustered index ‘%.*ls’ using drop clustered index clause.
3749
16
Cannot drop XML Index ‘%.*ls’ using old ‘Table.Index’ syntax, use ‘Index ON Table’ syntax instead.
3750
10
Warning: Index ‘%.*ls’ on %S_MSG ‘%.*ls’ was disabled as a result of disabling the clustered index on the %S_MSG.
3751
16
Cannot use SP_DROPEXTENDEDPROC or DBCC DROPEXTENDEDPROC with ‘%.*ls’ because ‘%.*ls’ is a %S_MSG. Use %ls.
3801
10
Warning: The index “%.*ls” on “%.*ls”.”%.*ls” may be impacted by the collation upgrade. Run DBCC CHECKTABLE.
3802
10
Warning: The constraint “%.*ls” on “%.*ls”.”%.*ls” may be impacted by the collation upgrade. Disable and enable WITH CHECK.
3803
10
Warning: The index “%.*ls” on “%.*ls”.”%.*ls” is disabled because the implementation of the checksum function has changed.
3804
10
Warning: The check constraint “%.*ls” on table “%.*ls”.”%.*ls” is disabled because the implementation of the checksum function has changed.
3805
10
Warning: Index “%.*ls” on table “%.*ls”.”%.*ls” might be corrupted because it references computed column “%.*ls” containing a non-deterministic conversion from string to date. Run DBCC CHECKTABLE to verify index. Consider using explicit CONVERT with deter
3806
10
Warning: Indexed view “%.*ls”.”%.*ls” might be corrupted because it contains a non-deterministic conversion from string to date. Run DBCC CHECKTABLE to verify view. Consider using explicit CONVERT with deterministic date style such as 121. Indexed views r
3807
17
Create failed because all available identifiers have been exhausted.
3808
10
Warning: The index “%.*ls” on “%.*ls”.”%.*ls” is disabled because the index is defined on a view with ignore_dup_key index option. Drop the index and, if possible, recreate it without ignore_dup_key option. You may need to change the logical structure of
3809
16
Upgrade of database “%.*ls” failed because index “%.*ls” on object ID %d has the same name as that of another index on the same table.
3810
10
Event notification “%.*ls” on assembly is dropped.
3811
10
Event notification “%.*ls” on service queue is dropped as broker instance is not specified.
3812
10
Event notification “%.*ls” on object is dropped.
3813
16
Upgrade of login ‘%.*ls’ failed because its name or sid is a duplicate of another login or server role.
3814
16
Local login mapped to remote login ‘%.*ls’ on server ‘%.*ls’ is invalid. Drop and recreate the remote login before upgrade.
3815
16
Local login mapped to linked login ‘%.*ls’ on server ‘%.*ls’ is invalid. Drop and recreate the linked login before upgrade.
3816
16
Upgrade of login ‘%.*ls’ failed because its password hash is invalid. Update the login password before upgrade.
3817
10
Warning: The index “%.*ls” on “%.*ls”.”%.*ls” was disabled because the implementation of geometry and geography methods have changed.
3818
16
CUID column of 6 bytes cannot be added to index “%.*ls” on object %.*ls because row length would exceed the maximum permissible length of %d bytes.
3819
10
Warning: The check constraint “%.*ls” on “%.*ls”.”%.*ls” was disabled and set as not trusted because the implementation of geometry and geography methods have changed.
3820
10
Warning: CUID column of 6 bytes has been added to index “%.*ls” on object %.*ls, but its maximum row size exceeds the allowed maximum of %d bytes. INSERT or UPDATE to this index will fail for some combination of large values.
3821
10
Warning: The foreign key constraint “%.*ls” on “%.*ls”.”%.*ls” was disabled because the implementation of geometry and geography methods have changed.
3822
10
Warning: The heap “%.*ls”.”%.*ls” has persisted computed columns that depends on a geometry or geography methods and may contain out-of-date information. Because of this, DBCC may report inconsistencies on this table. The persisted computed columns depen
3823
10
Warning: The object “%.*ls”.”%.*ls” could not be bound and was ignored during upgrade. Consider reviewing and correcting its definition.
3851
10
An invalid row (%ls) was found in the system table sys.%ls%ls.
3852
10
Row (%ls) in sys.%ls%ls does not have a matching row (%ls) in sys.%ls%ls.
3853
10
Attribute (%ls) of row (%ls) in sys.%ls%ls does not have a matching row (%ls) in sys.%ls%ls.
3854
10
Attribute (%ls) of row (%ls) in sys.%ls%ls has a matching row (%ls) in sys.%ls%ls that is invalid.
3855
10
Attribute (%ls) exists without a row (%ls) in sys.%ls%ls.
3856
10
Attribute (%ls) exists but should not for row (%ls) in sys.%ls%ls.
3857
10
The attribute (%ls) is required but is missing for row (%ls) in sys.%ls%ls.
3858
10
The attribute (%ls) of row (%ls) in sys.%ls%ls has an invalid value.
3859
10
Warning: The system catalog was updated directly in database ID %d, most recently at %S_DATE.
3860
10
Cannot upgrade database ID 32767. This ID value is reserved for SQL Server internal use.
3862
10
CLR type ‘%.*ls’.'%.*ls’ is disabled because the on disk format for this CLR type has been changed. Use DROP TYPE to remove this disabled type.
3864
23
Could not find an entry for index with ID %d on object with ID %d in database with ID %d. Possible schema corruption. Run DBCC CHECKDB.
3901
16
The transaction name must be specified when it is used with the mark option.
3902
16
The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.
3903
16
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.
3904
21
Cannot unsplit logical page %S_PGID in object ‘%.*ls’, in database ‘%.*ls’. Both pages together contain more data than will fit on one page.
3906
16
Failed to update database “%.*ls” because the database is read-only.
3908
16
Could not run BEGIN TRANSACTION in database ‘%.*ls’ because the database is in bypass recovery mode.
3909
16
Session binding token is invalid.
3910
16
Transaction context in use by another session.
3912
16
Cannot bind using an XP token while the server is not in an XP call.
3913
16
TDS reset connection protocol error. Client driver requested both ResetConnectionKeepLocalXact and ResetConnectionKeepDTCXact at the same time. This is not expected in server.
3914
16
The data type “%s” is invalid for transaction names or savepoint names. Allowed data types are char, varchar, nchar, varchar(max), nvarchar, and nvarchar(max).
3915
16
Cannot use the ROLLBACK statement within an INSERT-EXEC statement.
3916
16
Cannot use the COMMIT statement within an INSERT-EXEC statement unless BEGIN TRANSACTION is used first.
3917
16
Session is bound to a transaction context that is in use. Other statements in the batch were ignored.
3918
16
The statement or function must be executed in the context of a user transaction.
3919
16
Cannot enlist in the transaction because the transaction has already been committed or rolled back.
3920
10
The WITH MARK option only applies to the first BEGIN TRAN WITH MARK statement. The option is ignored.
3921
16
Cannot get a transaction token if there is no transaction active. Reissue the statement after a transaction has been started
3922
16
Cannot enlist in the transaction because the transaction does not exist.
3923
10
Cannot use transaction marks on database ‘%.*ls’ with bulk-logged operations that have not been backed up. The mark is ignored.
3924
10
The session was enlisted in an active user transaction while trying to bind to a new transaction. The session has defected from the previous user transaction.
3925
16
Invalid transaction mark name. The ‘LSN:’ prefix is reserved.
3926
10
The transaction active in this session has been committed or aborted by another session.
3927
10
The session had an active transaction when it tried to enlist in a Distributed Transaction Coordinator transaction.
3928
16
The marked transaction “%.*ls” failed. A timeout occurred while attempting to place a mark in the log by committing the marked transaction. This can be caused by contention with Microsoft Distributed Transaction Coordinator (MS DTC) transactions or other
3929
16
No distributed or bound transaction is allowed in single user database.
3930
16
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
3931
16
The current transaction cannot be committed and cannot be rolled back to a savepoint. Roll back the entire transaction.
3932
16
The save point name “%.*ls” that was provided is too long. The maximum allowed length is %d characters.
3933
16
Cannot promote the transaction to a distributed transaction because there is an active save point in this transaction.
3934
14
The current user cannot use this FILESTREAM transaction context. To obtain a valid FILESTREAM transaction context, use GET_FILESTREAM_TRANSACTION_CONTEXT.
3935
16
A FILESTREAM transaction context could not be initialized. This might be caused by a resource shortage. Retry the operation. Error code: 0x%x.
3936
16
The transaction could not be committed because an error occurred while tyring to flush FILESTREAM data to disk. A file may have been open at commit time or a disk I/O error may have occurred. ‘%.*ls’ was one of the one or more files involved. ErorrCode:
3937
16
While rolling back a transaction, an error occurred while trying to deliver a rollback notification to the FILESTREAM filter driver. Error code: 0x%0x.
3938
18
The transaction has been stopped because it conflicted with the execution of a FILESTREAM close operation using the same transaction. The transaction will be rolled back.
3939
16
An uncommittable transaction was detected at the beginning of the batch. The transaction was rolled back. This was caused by an error that occurred during the processing of a FILESTREAM request in the context of this transaction.
3950
16
Version store scan timed out when attempting to read the next row. Please try the statement again later when the system is not as busy.
3951
16
Transaction failed in database ‘%.*ls’ because the statement was run under snapshot isolation but the transaction did not start in snapshot isolation. You cannot change the isolation level of the transaction to snapshot after the transaction has started u
3952
16
Snapshot isolation transaction failed accessing database ‘%.*ls’ because snapshot isolation is not allowed in this database. Use ALTER DATABASE to allow snapshot isolation.
3953
16
Snapshot isolation transaction failed in database ‘%.*ls’ because the database was not recovered when the current transaction was started. Retry the transaction after the database has recovered.
3954
16
Snapshot isolation transaction failed to start in database ‘%.*ls’ because the ALTER DATABASE command that disallows snapshot isolation had started before this transaction began. The database is in transition to OFF state. You will either need to change t
3955
16
Snapshot isolation transaction failed in database ‘%.*ls’ because the recovery was skipped for this database. You must recover the database before you can run a transaction under snapshot isolation.
3956
16
Snapshot isolation transaction failed to start in database ‘%.*ls’ because the ALTER DATABASE command which enables snapshot isolation for this database has not finished yet. The database is in transition to pending ON state. You must wait until the ALTER
3957
16
Snapshot isolation transaction failed in database ‘%.*ls’ because the database did not allow snapshot isolation when the current transaction started. It may help to retry the transaction.
3958
16
Transaction aborted when accessing versioned row in table ‘%.*ls’ in database ‘%.*ls’. Requested versioned row was not found. Your tempdb is probably out of space. Please refer to BOL on how to configure tempdb for versioning.
3959
10
Version store is full. New version(s) could not be added. A transaction that needs to access the version store may be rolled back. Please refer to BOL on how to configure tempdb for versioning.
3960
16
Snapshot isolation transaction aborted due to update conflict. You cannot use snapshot isolation to access table ‘%.*ls’ directly or indirectly in database ‘%.*ls’ to update, delete, or insert the row that has been modified or deleted by another transacti
3961
16
Snapshot isolation transaction failed in database ‘%.*ls’ because the object accessed by the statement has been modified by a DDL statement in another concurrent transaction since the start of this transaction. It is disallowed because the metadata is no
3962
16
Bind to another transaction while executing SQL Server internal query is not supported. Check your logon trigger definition and remove any sp_bindsession usage if any. If this error is not happening during logon trigger execution, contact production suppo
3963
16
Transaction failed in database ‘%.*ls’ because distributed transactions are not supported under snapshot isolation.
3964
16
Transaction failed because this DDL statement is not allowed inside a snapshot isolation transaction. Since metadata is not versioned, a metadata change can lead to inconsistency if mixed within snapshot isolation.
3965
16
The PROMOTE TRANSACTION request failed because there is no local transaction active.
3966
17
Transaction is rolled back when accessing version store. It was earlier marked as victim when the version store was shrunk due to insufficient space in tempdb. This transaction was marked as a victim earlier because it may need the row version(s) that hav
3967
17
Insufficient space in tempdb to hold row versions. Need to shrink the version store to free up some space in tempdb. Transaction (id=%I64d xsn=%I64d spid=%d elapsed_time=%d) has been marked as victim and it will be rolled back if it accesses the version
3968
10
Snapshot isolation or read committed snapshot is not available in database ‘%.*ls’ because SQL Server was started with one or more undocumented trace flags that prevent enabling database for versioning. Transaction started with snapshot isolation will fai
3969
16
Distributed transaction is not supported while running SQL Server internal query. Check your logon trigger definition and remove any distributed transaction usage if any. If this error is not happening during logon trigger execution, contact production su
3970
16
This operation conflicts with another pending operation on this transaction. The operation failed.
3971
16
The server failed to resume the transaction. Desc:%I64x.
3972
20
Incoming Tabular Data Stream (TDS) protocol is incorrect. Transaction Manager event has wrong length. Event type: %d. Expected length: %d. Actual length: %d.
3973
16
The database is currently being used by another thread under the same workspace in exclusive mode. The operation failed.
3974
16
The number of databases in exclusive mode usage under a workspace is limited. Because the limit has been exceeded, the operation failed.
3975
16
The varchar(max) data type is not supported for sp_getbindtoken. The batch has been aborted.
3976
16
The transaction name has the odd length %d. The batch has been aborted.
3977
16
The savepoint name cannot be NULL. The batch has been aborted.
3978
16
Beginning a new transaction after rollback to save point is not allowed.
3979
16
The TM request is longer than expected. The request is not processed.
3980
16
The request failed to run because the batch is aborted, this can be caused by abort signal sent from client, or another request is running in the same session, which makes the session busy.
3981
16
The transaction operation cannot be performed because there are pending requests working on this transaction.
3982
16
New transaction is not allowed to be started while DTC or bound transaction is active.
3983
16
The operation failed because the session is not single threaded.
3984
16
Cannot acquire a database lock during a transaction change.
3985
16
An error occurred during the changing of transaction context. This is usually caused by low memory in the system. Try to free up more memory.
3986
19
The transaction timestamps ran out. Restart the server.
3987
10
SNAPSHOT ISOLATION is always enabled in this database.
3988
16
New transaction is not allowed because there are other threads running in the session.
3989
16
New request is not allowed to start because it should come with valid transaction descriptor.
3990
16
Transaction is not allowed to commit inside of a user defined routine, trigger or aggregate because the transaction is not started in that CLR level. Change application logic to enforce strict transaction nesting.
3991
16
The context transaction which was active before entering user defined routine, trigger or aggregate “%.*ls” has been ended inside of it, which is not allowed. Change application logic to enforce strict transaction nesting.
3992
16
Transaction count has been changed from %d to %d inside of user defined routine, trigger or aggregate “%.*ls”. This is not allowed and user transaction will be rolled back. Change application logic to enforce strict transaction nesting.
3993
16
The user transaction that has been started in user defined routine, trigger or aggregate “%.*ls” is not ended upon exiting from it. This is not allowed and the transaction will be rolled back. Change application logic to enforce strict transaction nesting
3994
16
User defined routine, trigger or aggregate tried to rollback a transaction that is not started in that CLR level. An exception will be thrown to prevent execution of rest of the user defined routine, trigger or aggregate.
3995
16
Unknown transaction isolation level %d, valid value range is 0 to 5.
3996
16
Snapshot isolation level is not supported for distributed transaction. Use another isolation level or do not use distributed transaction.
3997
16
A transaction that was started in a MARS batch is still active at the end of the batch. The transaction is rolled back.
3998
16
Uncommittable transaction is detected at the end of the batch. The transaction is rolled back.
3999
17
Failed to flush the commit table to disk in dbid %d due to error %d. Check the errorlog for more information.
 

sql server error list 3000 to 4000
sql server error list error codes 3000 to 4000
sql server error numbers 3000 to 4000
sql server error list 2005 3000 to 4000
sql server error list 2008 3000 to 4000
sql server 2008 error message list 3000 to 4000
sql server errors logs
sql server errors list table

1 comment:

  1. Step by step instructions to Solve MS SQL Server Error 3203 through Online MS SQL Server Support
    Confronting mistake 3203 in SQL Server? Or on the other hand can't get any sort of help to fathom this blunder message? Well! Try not to freeze, basically contact to Microsoft SQL Server Support and SQL Server Database Support to take care of this issue. In any case, before that you should know why this issue happens? The primary purpose for this issue is if arrange disappointment happens, in the event that you are utilizing Microsoft SQL Server 2014. Contact to Remote Infrastructure Management Support for Microsoft SQL Server.
    For More Info: https://cognegicsystems.com/
    Contact Number: 1-800-450-8670
    Email Address- info@cognegicsystems.com
    Company’s Address- 507 Copper Square Drive Bethel Connecticut (USA) 06801

    ReplyDelete