version 661. This server supports version 655 and earlier

Question

==================================

Attach database failed for Server 'OWNER-PC'. (Microsoft.SqlServer.Smo)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1447.4+((KJ_RTM).100213-0103+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

------------------------------
Program Location:

  at Microsoft.SqlServer.Management.Smo.Server.AttachDatabase(String name, StringCollection files)
  at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabaseData.PrimaryFile.Attach()
  at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabase.SendDataToServer()

===================================

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------
Program Location:

  at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
  at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
  at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)
  at Microsoft.SqlServer.Management.Smo.Server.AttachDatabaseWorker(String name, StringCollection files, String owner, AttachOptions attachOptions)
  at Microsoft.SqlServer.Management.Smo.Server.AttachDatabase(String name, StringCollection files)

===================================

The database 'omegalove' cannot be opened because it is version 661. This server supports version 655 and earlier. A downgrade path is not supported.
Could not open new database 'omegalove'. CREATE DATABASE is aborted. (.Net SqlClient Data Provider)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=948&LinkId=20476

------------------------------
Server Name: OWNER-PC
Error Number: 948
Severity: 20
State: 1
Line Number: 1


------------------------------
Program Location:

  at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
  at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
  at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

---

Mathieu Alexandre Cupryk www.omegalove.com

Answer 1

SQL Server 2008 databases are version 655. SQL Server 2008 R2 databases are 661.

You are trying to attach an SQL Server 2008 R2 Database to a SQL Server 2008 instance. You cannot do that.

You need to have SQL Server 2008 R2 instance to be able to attach your database.

---

Ali Hamdar (alihamdar.com - www.ids.com.lb)

Answer 2

Is there an update?

---

Mathieu Alexandre Cupryk www.omegalove.com

Answer 3

Upgrading to SQL Server 2008 R2 is there a link?

---

Mathieu Alexandre Cupryk www.omegalove.com

Answer 4

See the SQL Server 2008 R2 Books Online (http://msdn.microsoft.com/en-us/library/bb677622.aspx) for upgrade instructions.  Note that SQL Server 2008 R2 is an entirely new release, not just a patch level.  You will need the new installation media and license in order to install.

 

 

 

---

Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/