SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SQL Version Issue - 661
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ismail_issac
Starting Member

22 Posts

Posted - 07/22/2012 :  05:17:42  Show Profile  Reply with Quote
Hi

I need urgent help.
When I attach a DB (SQL 2005) on my machine it gives error message that the DB version is 661 and my machine supports version 612.

Can any one please give me link to upgrade my SQL 2005 version to 661

Thank you.

sunitabeck
Flowing Fount of Yak Knowledge

5155 Posts

Posted - 07/22/2012 :  06:16:46  Show Profile  Reply with Quote
661 is SQL Server 2008 R2. Upgrading from SQL 2005 to SQL 2008 R2 is not a simple service pack or patch - it involves lot more planning, money and resources.

This link gives you information about the various internal version numbers: http://weblogs.sqlteam.com/dang/archive/2011/07/17/internal-sql-server-database-version-numbers.aspx

This link takes you to the download site for Microsoft. There are evaluation versions that you can download and use to examine the database, but for production uses you will need to purchase appropriate licenses: http://technet.microsoft.com/en-us/sqlserver/ff398089.aspx
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 07/23/2012 :  13:33:17  Show Profile  Visit russell's Homepage  Reply with Quote
661 is SQL 2008 (not R2).

You can't attach a higher version (SQL 2008) to a lower one (SQL 2005)

Go to Top of Page

sunitabeck
Flowing Fount of Yak Knowledge

5155 Posts

Posted - 07/23/2012 :  14:46:59  Show Profile  Reply with Quote
quote:
Originally posted by russell

661 is SQL 2008 (not R2).

You can't attach a higher version (SQL 2008) to a lower one (SQL 2005)



Thanks russel, you are right. My mistake.
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 07/24/2012 :  11:36:47  Show Profile  Visit russell's Homepage  Reply with Quote
You don't make many, that's for sure.
Go to Top of Page

sunitabeck
Flowing Fount of Yak Knowledge

5155 Posts

Posted - 07/24/2012 :  19:30:48  Show Profile  Reply with Quote
You don't make many either, but I think you made one here!
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000