•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 426,807 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 1,838 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser: Programming Forums
Views: 390 | Replies: 0
![]() |
•
•
Join Date: Jul 2007
Posts: 12
Reputation:
Rep Power: 2
Solved Threads: 0
company is using SQL version 7 to support heavy many ASP program
last weekend, I try to upgrade it by installing extra SQL version 2000 (a software that company got) -- to try to aim for failover custer for the future
then I can't find the enterprise manager console from SQL server 2000
====
those analytics service etc (advanced stuff) seem to be in START --> program .... (but not the core)
===
then I uninstall SQL server 2000 during last weekend
==
today, I put the SQL server 2000 there again, while the Database is LIVE and serving many ASP program (i.e. I did not stop it -- in the past, this does not produce fatal error)
the big mistake -- I choose UPGRADE to 2000 (during installation) and then replace the INSTANCE of existing SQL server v 7
then oooops
the whole SQL -- whatever version , is DOWN
and I can't really unintall SQL server 2000
===
I reinstall SQL server v7, and try to ATTACH an important database (forgot to detach it first, and forgot to detach and attach MASTER database first)
the whole thing won't work
===
still fixing the issue as the company rely on many database there (in that server)
what is the proper STEP of doing it - they upgrade got so much issue
(did search on net, maybe you expertise guys could lead me the PROPER way of doing it)
thanks
last weekend, I try to upgrade it by installing extra SQL version 2000 (a software that company got) -- to try to aim for failover custer for the future
then I can't find the enterprise manager console from SQL server 2000
====
those analytics service etc (advanced stuff) seem to be in START --> program .... (but not the core)
===
then I uninstall SQL server 2000 during last weekend
==
today, I put the SQL server 2000 there again, while the Database is LIVE and serving many ASP program (i.e. I did not stop it -- in the past, this does not produce fatal error)
the big mistake -- I choose UPGRADE to 2000 (during installation) and then replace the INSTANCE of existing SQL server v 7
then oooops
the whole SQL -- whatever version , is DOWN
and I can't really unintall SQL server 2000
===
I reinstall SQL server v7, and try to ATTACH an important database (forgot to detach it first, and forgot to detach and attach MASTER database first)
the whole thing won't work
===
still fixing the issue as the company rely on many database there (in that server)
what is the proper STEP of doing it - they upgrade got so much issue
(did search on net, maybe you expertise guys could lead me the PROPER way of doing it)
thanks
![]() |
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
ajax asp capable computer database decimal seperator thousand seperator when using sql server deleting records from ms sql table where columns have duplicate values dell dell dimension 5150 developer development downtime forum gartner hacker management studio 2005 microsoft msdn news office operating security software sql sql cache dependency with polling-based invalidation survey system upgrade vbulletin vista windows xp
- Previous Thread: Backup db to external hd?
- Next Thread: ASP and MSSQL : Microsoft OLE DB Provider for ODBC Drivers error '80040e14'


Linear Mode