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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-10-14 : 09:15:01
|
| Fred writes "Scenario: trying to import a SQL65 DB to SQL2000.The SQL65 box (ServerA) is NTSP6a, has SQL65SP5a and is in Domain A (NT).The SQL2K box (ServerB) is Win2K, SP2, with SQL2KSP2 and is in Domain B (AD).Both are PDCs. There is full trust between domains and Identical users are created as Domain Admins in each for the service startups. The Domain B SQLAdmin is added to the Domain A Domain Admins group. I'm logged onto ServerB as SQLAdmin to Domain B.When trying to run the SQL Server Upgrade Wizard on the SQL2K box, after entering the correct SA passwords for each the wizard gives a message that it must stop and restart SQL on both boxes. I click OK. Within 1 second (on a new Dell6400/700), I got an error with the following text:The import server MUST be switched to SQL Server 2000There is only one instance of SQL2K on ServerB, and no other version has ever been installed. There are no other DB apps on the machine, though I did uninstall DAO3.5, after which I uninstalled and re-installed SQL2K with SP2. The box has NOrton AV (turned off) and Backup Exec (removed as a last resort), PCAnywhere, HP Web Jetadmin, Adobe Acrobat, Winzip and Windows HF Q300972. ServerB has been restarted many times.Any clues?" |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2002-10-16 : 06:54:37
|
| You can't upgrade a DB straight from 6.5 to 2k. You have to either upgrade via 7 or Create an empty DB and use DTS to import your data. |
 |
|
|
JamesH
Posting Yak Master
149 Posts |
Posted - 2002-10-16 : 08:11:03
|
| The last information that you received from RickD was incorrect. You can upgrade from 6.5 to 2000 although you are forced to use the upgrade wizard. (You cannot attach or restore a 6.5 DB to 2000)Ref: BOL FAQ in "Upgrading SQL Server", Question Number 5. Can you restore or attach a SQL Server 6.5 database to SQL Server 2000?A. No. The only way to move a SQL Server 6.5 database to SQL Server 2000 is to run the SQL Server Upgrade Wizard.I would suggest that if you haven't went to the DESTINATION Server and selected Files.Programs.Microsoft SQL Server - Switch.SQL Server Upgrade Wizard that you try this approach. If you have used this method and it failed. Install SQL 2000 on the (ServerA) SQL65 box and then try running the upgrade wizard from there and then detaching your databases and moving them to your new server. If all of this fails send the error message numbers and we can work from there. JamesH. |
|
|
|
|
|
|
|
|
SQL Server doesn't recognize itself?