Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2010-09-15 : 03:53:37
|
| Hi All,One of my left out SQL DBA while installing SQL Server 2000 licensed version of STANDARD EDITION by mistake he had selected as "Desktop Engine".So we had problem with DB growth after 2GB.Now we have a installation CD can we install with SQL server Standard on top of the Desktop Engine.What are the pre requisites to take into considarations ?Thanks,Gangadhar |
|
|
DuncanP
Starting Member
12 Posts |
Posted - 2010-09-15 : 05:43:33
|
| You can upgrade an MSDE installation to SQL Standard, or you can install SQL Standard side-by-side and copy the datafiles from MDSE to SQL Server using the detach/attach method. Personally, I'd go with the side-by-side and copy approach, as it always seems somehow safer to me.There's lots of information in this link:[url]http://support.microsoft.com/kb/325023[/url]Duncan |
 |
|
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
Posted - 2010-09-15 : 05:51:12
|
| Basically my MSDE and SQL server 2000 standard edition both are in the same machine ..!! So i can't do side-by -side up gradation.Can u pls help me with the steps ?I have MSDE installed on the same machine i should have SQL server 2000 standard edition needs to be upgraded |
|
|
|
DuncanP
Starting Member
12 Posts |
Posted - 2010-09-15 : 06:24:36
|
| If you already have SQL Standard installed on the same machine as MDSE, you can just move (detach/attach) the databases from MSDE to SQL Server - there's a bit about how to do that in that link I gave. You can then point any applications at the SQL Standard Server.If you haven't got SQL Standard installed, then you can install it without overwriting MDSE (hence side-by-side) and detach/attach the relevant database(s).Does any of that make any sense?Duncan |
|
|
|
|
|
|
Issue with Installation