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-02-06 : 07:39:47
|
| Darren writes "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!" |
|
|
chadmat
The Chadinator
1974 Posts |
|
|
|
|
|
Cannot Restore SQL 7 db (user errors) 