SQL Server Errors or Failures Error: 3204 to Error: 3223



Error: 3204, Severity: 16, The backup or restore was aborted.,
Error: 3205, Severity: 16, Too many backup devices specified for backup or restore; only %d are allowed.,
Error: 3206, Severity: 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.,
Error: 3207, Severity: 16, Backup or restore requires at least one backup device. Rerun your statement specifying a backup device.,
Error: 3208, Severity: 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.,

Error: 3209, Severity: 16, Operation is not supported on user instances.,
Error: 3210, Severity: 16, The mirror member in drive “%ls” is inconsistent with the mirror member in drive “%ls”.,
Error: 3211, Severity: 10, %d percent processed.,
Error: 3212, Severity: 16, The mirror device “%ls” and the mirror device “%ls” have different device specifications.,
Error: 3213, Severity: 16, Unable to unload one or more tapes. See the error log for details.,
Error: 3214, Severity: 16, Too many backup mirrors are specified. Only %d are allowed.,
Error: 3215, Severity: 16, Use WITH FORMAT to create a new mirrored backup set.,
Error: 3216, Severity: 16, RESTORE REWINDONLY is only applicable to tape devices.,
Error: 3217, Severity: 16, Invalid value specified for %ls parameter.,
Error: 3218, Severity: 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.,

Error: 3219, Severity: 16, The file or filegroup “%.*ls” cannot be selected for this operation.,
Error: 3220, Severity: 16, The specified URL points to a Block Blob. Backup and Restore operations on Block Blobs are not permitted.,
Error: 3221, Severity: 16, The ReadFileEx system function executed on file ‘%ls’ only read %d bytes, expected %d.,
Error: 3222, Severity: 16, The WriteFileEx system function executed on file ‘%ls’ only wrote %d bytes, expected %d.,
Error: 3223, Severity: 16, Backup To URL failed to write status messages to the Windows Event Log.,

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.


Leave a Reply

Your email address will not be published. Required fields are marked *