September 7, 2009 at 8:07 am
Hi
I have got the SQL server 2005 enterprise, but it have 2 CDs, so what are the differences between CD1 and CD2? and so which one should i install first? or is it necessary to install both two or just need to install one of them?
And about my original sql 2000 database, can i just attach it's MDF file into the sql 2005 engine, or which import wizard can load the sql 2000 MDF into sql 2005? or do i need to keep the sql 2000 engine before do this?
Thx
Bhavesh
September 7, 2009 at 8:29 am
bhavesh_183 (9/7/2009)
HiI have got the SQL server 2005 enterprise, but it have 2 CDs, so what are the differences between CD1 and CD2? and so which one should i install first? or is it necessary to install both two or just need to install one of them?
And about my original sql 2000 database, can i just attach it's MDF file into the sql 2005 engine, or which import wizard can load the sql 2000 MDF into sql 2005? or do i need to keep the sql 2000 engine before do this?
Thx
Bhavesh
Disk 1 is the server, disk 2 is the client if i remember correctly.
attach/restore from sql 2000 to sql 2005 and it will do upgrade.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 7, 2009 at 8:43 am
Actually I have got SQL SERVER 2005 as ‘dump’ of 2 CDs. I can install all the components from dump of CD1 (SQLSRVRS) without any problem.
But the trouble starts when I want to install components form dump of CD2(SQLTOOLS). It gives me following error
“The following components that you chose to install are already installed on the machine. To view a report of available options and alternatives click on Details.”
None of the components are getting installed from CD2.
I can only use the ‘SQL SERVER Management Studio” after above installation.
--- The machine does not get configured as a ‘SQL SERVER’
Any way out??
Regards,
Bhavesh
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply