Problem with attaching database

Question

Post reply

Problem with attaching database

Dugi

SSCoach

Points: 17998
More actions
May 21, 2008 at 3:51 am

#191345

Hello!
I have problem attaching database, it works good but when I try SQL Server 2008 - I just upgrade from SQL Server 2005 to 2008 also it works, but when I format my PC and again installing SQL Server 2005 not working more just Northwind database it hasn't any problem I can attach it without any problem!
and there is my msg info during attaching database and fails!
============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

VastSQL SSC-Dedicated Points: 36121 More actions · Answer 1

I think you tried to attach a SQL Server 2008 DB in SQL Server 2005.You cant attach 2008 DB in 2005

Dugi SSCoach Points: 17998 More actions · Answer 2

Ratheesh.K.Nair (5/21/2008)
I think you tried to attach a SQL Server 2008 DB in SQL Server 2005.You cant attach 2008 DB in 2005

from the msg info it seems like you write I know but any suggestion how to bring it up in SQL Server 2005 couz it created in SQL Server 2005 and just attached in SQL Server 2008! The same situation is with northwind database but I don't have any problem with, I just attached it!

:w00t:

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

KenpoDBA SSCrazy Eights Points: 9811 More actions · Answer 3

He's right... you can't attach downward.

Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant

Minion Maintenance is FREE:

Dugi SSCoach Points: 17998 More actions · Answer 4

crever (5/21/2008)
He's right... you can't attach downward.

but with Northwind it's ok ...!:hehe:

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

the__t Hall of Fame Points: 3260 More actions · Answer 5

Hopefully you took a backup of the 2005 database?

"Got no time for the jibba jabba!"
-B.A. Baracus