Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Not Able to Connect Sql 2005 Database in Sql 2000 Expand / Collapse
Author
Message
Posted Thursday, November 21, 2013 9:46 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, February 14, 2014 7:24 PM
Points: 25, Visits: 40
Hai Every Body

I Have a Database Which was attached in Sql Server 2005.When I Try To Attach it in Sql 2000 Server.
I am not Able to attach it.Is there any Way to Attach it.

Please Help Me.



Thanks
Post #1516637
Posted Friday, November 22, 2013 2:30 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 1:20 AM
Points: 578, Visits: 3,755
What is your compatibility level set to on the database?

To figure it out, right-click the database, go to Properties and then Options. I would bet that it's set to 2005 (like 80 or 90).
Post #1516942
Posted Friday, November 22, 2013 8:20 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, February 14, 2014 7:24 PM
Points: 25, Visits: 40
Hai
Thanks for your Reply.

When i Check the compatibility level it was SQL Server 2000(80).


Still it was not attaching.

What i observed is when i attach data base in higher version i.e. SQL Server 2005,it was not attaching in the lower version i.e. SQL Server 2000.

Is there any way to attach?

Post #1516993
Posted Friday, November 22, 2013 8:56 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 1:20 AM
Points: 578, Visits: 3,755
You can attach to lower versions, but not higher ones.
Post #1516994
Posted Saturday, November 23, 2013 10:56 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 10:24 AM
Points: 22,507, Visits: 30,225
You can not attach a database from SQL Server 2005 to SQL Server 2000 regardless of the compatibility mode. Once you attach or restore a database from SQL Server 2000, it is for all intents and purposes a SQL Server 2005 database.

The only way you will be able to move the database from SQL Server 2005 to SQL Server 2000 is to 1) Script out the all the database objects and run that on your SQL Server 2000 system, 2) use SSIS to move the data from SQL Server 2005 to SQL Server 2000.




Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1517024
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse