SQL Server Errors or Failures Error: 3156 to Error: 3181



Error: 3156, Severity: 16, File ‘%ls’ cannot be restored to ‘%ls’. Use WITH MOVE to identify a valid location for the file.,
Error: 3159, Severity: 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,
Error: 3161, Severity: 16, The primary file is unavailable. It must be restored or otherwise made available.,

Error: 3163, Severity: 16, The transaction log was damaged. All data files must be restored before RESTORE LOG can be attempted.,
Error: 3165, Severity: 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.,
Error: 3166, Severity: 16, RESTORE DATABASE could not drp database ‘%ls’. Drop the database and then reissue the RESTORE DATABASE statement.,
Error: 3167, Severity: 16, RESTORE could not start database ‘%ls’.,
Error: 3168, Severity: 16, System.Data.SqlClient.SqlError: 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). (Microsoft.SqlServer.Smo)
Restore of System databases Master, Model and MSDB cannot be restored from different version to different version of SQL Server instance.

Example: SQL Server 2008 R2 Sp1 system databases backup cannot be restored on SQL Server 2008 R2 RTM version instance. You need to use the system database backup performed on same build.

Error: 3169, Severity: 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.,
Error: 3170, Severity: 16, The STANDBY filename is invalid.,
Error: 3171, Severity: 16, File %ls is defunct and cannot be restored into the online database.,
Error: 3172, Severity: 16, Filegroup %ls is defunct and cannot be restored into the online database.,
Error: 3173, Severity: 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,
Error: 3174, Severity: 16, The file ‘%ls’ cannot be moved by this RESTORE operation.,
Error: 3175, Severity: 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.,
Error: 3176, Severity: 16, File ‘%ls’ is claimed by ‘%ls'(%d) and ‘%ls'(%d). The WITH MOVE clause can be used to relocate one or more files.,
Error: 3178, Severity: 16, File %ls is not in the correct state to have this differential backup applied to it.,
Error: 3179, Severity: 16, The system database cannot be moved by RESTORE.,
Error: 3180, Severity: 16, This backup cannot be restored using WITH STANDBY because a database upgrade is needed. Reissue the RESTORE without WITH STANDBY.,
Error: 3181, Severity: 10, Attempting to restore this backup may encounter storage space problems. Subsequent messages will provide details.,

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 *