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 |
|
thecoffeeguy
Yak Posting Veteran
98 Posts |
 Posted - 2007-01-19 : 16:21:39
|
| In a nutshell, I need to copy our production database server to a test environment server (both servers running sql 2000).I need to make sure I copy over the usernames and passwords as well.Any recommendations here? I see I can probably do a copy DB wizard, or would it be best to use the analyzer?Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-19 : 16:36:45
|
| Just backup the prod database, copy the backup file to your other environment, then do a restore. To copy users and passwords, I use this:http://www.sqlmag.com/articles/index.cfm?articleid=16090&The copy DB wizard over-complicates a simple task. Plus it doesn't get you everything anyway.Tara Kizer |
 |
|
|
thecoffeeguy
Yak Posting Veteran
98 Posts |
Posted - 2007-01-19 : 17:11:03
|
quote:
Originally posted by tkizer
Just backup the prod database, copy the backup file to your other environment, then do a restore. To copy users and passwords, I use this:http://www.sqlmag.com/articles/index.cfm?articleid=16090&The copy DB wizard over-complicates a simple task. Plus it doesn't get you everything anyway.Tara Kizer
Thanks for the link.After I do a full backup of the prod DB, do I need to restore any tlog backups after that to the test db AFTER I restore the fullbackup? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-19 : 17:15:12
|
| Only if you want to...Tara Kizer |
|
|
|
|
|
|
Copying a database from one server to another?