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 |
|
dfarmer
Starting Member
2 Posts |
 Posted - 2002-01-31 : 17:08:09
|
| I'm trying to copy a database from one server to another. I'm attempting to do this by restoring a SQL 7 DB from a saved disk backup.The FULL backup works fine. I'm only backing up "db1" with all objects, tables, etc.I then proceed to do a restore... but it keeps bombing on the restore part because the users are not present in the new database.I've also tried doing this as an export from on database to another. But it also fails because the users are not in the new database.Am I missing something? Do I need to copy the Master DB too? How do I copy the users w/o having to install each and EVERY one .... individually...? (There are 500+)Is there a better way to restore/copy a db from one server to another? I can't figure out why it's bombing out on the part where it adds users. (I'm trying to copy my database from prod to test... but exact mirror copies)Thanks! |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-01-31 : 17:47:22
|
| If there are logins on your old server that own objects in the database you are trying to move those objects will error out. You'll need to copy the logins form one server to the other. The SQL 7 Copy DB Wizard does not support coping logins for security reasons, but I believe the fixed that in 2000. I have a couple of scripts that might help you transfer the logins and their passwords. I'll post them in the Script Library Forum.Jeff BanschbachConsultant, MCDBA |
 |
|
|
dfarmer
Starting Member
2 Posts |
Posted - 2002-02-01 : 10:24:25
|
| thanks for all your help... i'll check out the script forum.-Darren |
|
|
|
|
|
|
Cannot Restore SQL 7 db (user errors)