Export (0) Print
Expand All
Expand Minimize

MSSQLSERVER_3169

Product Name

SQL Server

Product Version

10.50

Product Build Number

10.50.1281.60

Event ID

3169

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic Name

NA

Message Text

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.

Certain features in SQL Server affect the structure of the database files. When you restore a database to another instance of SQL Server, the file format might not be compatible with a different version of the SQL Server Database Engine.

For example, this error can be caused by using the vardecimal storage format in a later version of SQL Server and then trying to restore the database files in a version earlier than SQL Server 2005 Service Pack 2.

Determine the version of SQL Server that is running on the originating server. In SQL Server Management Studio, either right-click the server and then click Properties or type SELECT @@VERSION in a query window. Open the database by using the original version of SQL Server. Investigate the features that are enabled on the original database in the instance of SQL Server. Modify these settings to work with the version of SQL Server in which the database will be restored.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft