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 |
|
nstimely
Starting Member
6 Posts |
 Posted - 2004-08-23 : 18:53:57
|
Hello!!I was wondering what the easiest, safest way to clone my production db would be? Can I copy my live production database with the database copy wizard? If I do a restore of the backed up database to another server will it contain all my users/roles/grants? If not, what is the easiest way to get the information? I do not want to impact my production users and would like a periodic refresh of my system with current data. I have just seen where the logins do not come over when copying databases.  Thank you!NS |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-08-23 : 19:05:15
|
| A backup/restore will include the users/roles/grants. As will a detach/attach. These would be the easiest and quickest methods to clone your db. Be aware, though, that the users list for each database references the server-level logins list. So, you'll need to make sure that they're the same on both servers (assuming you want to test or use all of the logins). |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-24 : 23:58:42
|
| For refreshing a copy of production, use replication or backup/restore. Then run sp_help_revlogin on the master database of the source server. Run the results of that on the destination server.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Copying Help!