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 |
|
ssanchez02
Starting Member
5 Posts |
 Posted - 2004-08-23 : 18:58:43
|
| Newbie here. I have a SQL7 user database that I want to move to a new SQL2000 server. I've exported the SQL7 database as a file, created the database on the SQL2000 server and tried to do a restore database from a device and pointing to the file. Unfortunately, I received errors which seem to relate to the fact that the file path information on the old SQL7 server (G:) is different than the new SQL2000 server (C:).As I said, I'm a newbie here and I'm wondering if I'm trying to do too many things at once (migrating from SQL7 to 2000, moving from one box to another, etc.).Can anyone tell me what I'm doing wrong, or even better, tell me the steps (or point me to a web page) where I can learn the steps to do this?Many thanks for your help! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-23 : 19:00:05
|
| You need to use the WITH MOVE option of the RESTORE command.Example:RESTORE DATABASE DB1FROM DISK = 'E:\SomeFileName.BAK'WITH REPLACE, MOVE 'DB1_Data' TO 'F:\MSSQL\DATA\DB1_Data.MDF',MOVE 'DB1_Log' TO 'G:\MSSQL\DATA\DB1_Log.LDF'Tara |
 |
|
|
ssanchez02
Starting Member
5 Posts |
Posted - 2004-08-23 : 20:02:24
|
| Thanks for the quick reply. I have been able to do my restore and the database is in place. However, I am having problems accessing it.I've confirmed the database and the data. But I can't create a user that can access the database. When I restored the database, the user I want to use seems to have came over, but is not under the Security/Logins list. I created the New Login under Security/Logins, but when I try to assign it to my database and it asks to confirm the password, I get an error that the confirmation password is incorrect. I've got the database in place; how do I create/recreate the user that can access the database?Thanks again! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ssanchez02
Starting Member
5 Posts |
Posted - 2004-08-24 : 15:02:07
|
| Worked like a charm. Thank you so much for the help. I never would have found this. |
|
|
|
|
|
|
|
|
Moving SQL7 DB to new SQL2000 server