SQL Server 2008 R2 Attachment Problem

Posted by Naeem2049 under Sql Server on 1/11/2011 | Points: 10 | Views : 4558 | Status : [Member] | Replies : 5
Hi,

When i want to attach any DB to SQL Server 2008 R2 Even the DB i want to attach is the DB of same SQL Server 2008 R2 version.... The error message Like this:

The database cannot be opened because it is version 661. This version supports version 612 and earlier. A downgrade path is not supported.

Please help me in this issue ... Even i repair again and again my SQL Server 2008 R2 .

Thanks in Advance.......

Regards
NAEEM




Responses

Posted by: PandianS on: 1/11/2011 [Member] [MVP] Silver | Points: 25

Up
0
Down
Hi

1. When you try to attach the database with SQL Server 2008 the database compressed and automatically upgraded from SQL 2005 to to SQL Server 2008.

2. So, The actual structure of the database modified to the new version automatically.

Note: What is the database(Detached database) version which you want attach ?

Cheers
www.sqlserverbuddy.blogspot.com

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Naeem2049, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Naeem2049 on: 1/11/2011 [Member] Starter | Points: 25

Up
0
Down

Hi,

I have SQL Server 2008 R2 version Database running on different system I want to attach that Database in my system also have SQL Server 2008 R2 version in it.

But when going to attach process have an error as i mentioned in the above message.....

Hope you got the idea what actually want.....

Thanks for reply and advance for help.......

Regards
NAEEM

Naeem2049, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Hemadri on: 1/11/2011 [Member] Starter | Points: 25

Up
0
Down
Hi

There are two different method to setup sample database. 1) Running SQL Script 2) Restoring Database Backup. There are few common steps in both the process. We will see the common process first and then after see both the method to setup sample database in detail.

Common Steps:

Download the .msi package from codeplex based on your operating system and your SQL Server version. I have used Adventureworks DB version of 2005 as that is what was question from user. If you download version of 2008 it can only be installed in version of 2008.

Web development services

Naeem2049, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: PandianS on: 1/11/2011 [Member] [MVP] Silver | Points: 25

Up
0
Down
Hi

Can you try to Backup and Restore it ? Instead of Detach and Attach.

Cheers
www.sqlserverbuddy.blogspot.com

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Naeem2049, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Karthikanbarasan on: 1/11/2011 [Member] [Moderator] [Microsoft_MVP] [MVP] Silver | Points: 25

Up
0
Down
Hi,

Check the below links

http://msdn.microsoft.com/en-us/library/ms190794.aspx
http://technet.microsoft.com/en-us/library/ms189625.aspx

Do the steps to detach and attach the process it will work

Thanks
Karthik
www.f5Debug.net

Naeem2049, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response