for that you have to set Compatible Level of your sql server 2005 usign this you can allso attach 2008 database into 2005 for that you can refer this site they can give solution in the detail please follow his steps.
Hi Vipul thank you for your reply but TheBeerHouseVB.mdf which having compatibility of 2008 but i am not able to attach so i dont understand how do i execute this code
ALTER DATABASE SET SINGLE_USER TheBeerHouseVB
GO EXEC sp_dbcmptlevel TheBeerHouseVB,
90; GO ALTER DATABASE TheBeerHouseVB SET MULTI_USER
GO
when ever i copied in my data folder in sqlserver in program file and try to execute i database does't exist. i dont understand unless untill i donot attached how do i execute.. or some where i do mistake
which i not following ... can u please help me.
ya yoou are write. My office is using Sqlserver2005 with licence. so i am not able to install without admin permission. so is there any other way to solve this.
shekhar1983
Member
3 Points
34 Posts
Cannot open "TheBeerHouseVB" database.
Nov 09, 2009 04:41 AM|LINK
Hi,
Can anyone please solve my problem. When i try to attach the database the following error comes
"The database 'TheBeerHouseVB' cannot be opened because it is version 655. This server supports version 611 and earlier".
i have gone through some blog and come to know that this .mdf has been created in sqlserver 2008. But i have sqlserver2005
can anyone please make a script with data for sqlserver2005 and send my mail id shekhar.manna@live.com.
Or do you have any better solution can you please share with me.
Thanks
Shekhar
Mikesdotnett...
All-Star
154852 Points
19855 Posts
Moderator
MVP
Re: Cannot open "TheBeerHouseVB" database.
Nov 09, 2009 06:29 AM|LINK
Why don't you download and install Sql Server Express 2008? It's free.
Beginning ASP.NET Web Pages with WebMatrix | My Site | Twitter
vipuldonga
Contributor
3753 Points
692 Posts
Re: Cannot open "TheBeerHouseVB" database.
Nov 09, 2009 06:32 AM|LINK
Hi,
for that you have to set Compatible Level of your sql server 2005 usign this you can allso attach 2008 database into 2005 for that you can refer this site they can give solution in the detail please follow his steps.
http://blog.sqlauthority.com/2007/05/29/sql-server-2005-change-database-compatible-level-backward-compatibility/
Vipul Donga
Mark it as an answer, if it helped
if (MyAnswer)
MarkAsAnswer();
else
Repsonse.Write("correct me where i am wrong");
shekhar1983
Member
3 Points
34 Posts
Re: Cannot open "TheBeerHouseVB" database.
Nov 09, 2009 09:24 AM|LINK
Hi Vipul thank you for your reply but TheBeerHouseVB.mdf which having compatibility of 2008 but i am not able to attach so i dont understand how do i execute this code
ALTER DATABASESET SINGLE_USER
TheBeerHouseVBGO
EXEC sp_dbcmptlevel TheBeerHouseVB, 90;
GO
ALTER DATABASE TheBeerHouseVB
SET MULTI_USER
GO
when ever i copied in my data folder in sqlserver in program file and try to execute i database does't exist. i dont understand unless untill i donot attached how do i execute.. or some where i do mistake which i not following ... can u please help me.
shekhar1983
Member
3 Points
34 Posts
Re: Cannot open "TheBeerHouseVB" database.
Nov 09, 2009 12:24 PM|LINK
Hi Mike,
ya yoou are write. My office is using Sqlserver2005 with licence. so i am not able to install without admin permission. so is there any other way to solve this.
Thank you for your reply
Shekhar