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
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
Step by step instructions to Solve MS SQL Server Error 3203 through Online MS SQL Server Support
ReplyDeleteConfronting 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