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 |
|
Jay1Jay
Yak Posting Veteran
50 Posts |
 Posted - 2003-06-13 : 11:19:00
|
| I have a SQL6.5 Database on Server1 and would have taken a backup of that database. I would like to import this backup databse on Server#2 which is also running SQL6.5. How do I do that. Also how do I go about upgrading from 6.5 to 2000. Do I need to update to 7.0 than 2000 or can I directly go to 2000. Ihave a new win2000 server with Sql2000 installed and will be using this new server for my application, but how do i go about moving that 6.5 databse to new SQL 2000 server..thanks,Jay |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-06-13 : 12:16:31
|
| If you have the backup on the source database, then just copy it over to the destination server and peform a restore. You will need to unorphan the accounts after the restore using sp_change_users_login. Chadmat has a script to do this, so search the script library for it. You do not need to upgrade to 7.0 first. You can upgrade directly from 6.5 to 2000. What you have described is called the two server method. You just need to run the Upgrade wizard and walk through those screens which will ask you which servers are you using. After the upgrade, you will want to change the database compatibility level to 80 if that applies in your case. Please see BOL for details about this.Tara |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-06-14 : 00:03:50
|
| If I remember correctly, it isn't that easy in 6.5. I believe you need to setup a device on the destination server with the same log/data structure as the source, then restore to that device.My script is for 7.0 or 2000. I don't even think sp_change_users_login even existed in 6.5.You would be better off doing a 2 machine upgrade and leave 6.5 off the new machine.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-06-14 : 02:48:35
|
| sp_change_users_login is available in 6.5, but I can't remember what parameters it accepts. I'm almost positive that UPDATE_ONE is one of the parameters. With the two server method, you won't need to worry about this though.Tara |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-06-14 : 05:04:00
|
| It appears you are right. 6.5 does include sp_change_users_login, but I have never run my script against 6.5, so I can't guarantee it will work as it should. -Chad http://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
|
|
|
SQL6.5 Import