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 |
|
sent_sara
Constraint Violating Yak Guru
377 Posts |
 Posted - 2013-05-09 : 13:01:58
|
| Hi,Is user account will be copied during database restoration from production to development or we need to create each and every time during restoration? |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2013-05-09 : 13:37:29
|
| The USERs are a database level concept and will be restored with the database. The LOGINs are a server level concept and are NOT carried forward by a database restore. You will want to verify that the IDs of the LOGIN and USER are the same.=================================================There are two kinds of light -- the glow that illuminates, and the glare that obscures. -James Thurber |
 |
|
|
srimami
Posting Yak Master
160 Posts |
Posted - 2013-05-10 : 03:14:51
|
| Hi Sara,I go with Bustaz; as long as logins are present with same user, your DB restore from Dev to prod shouldn't have any problem.Thanks. |
|
|
|
|
|
|
user account