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 |
|
system243trd
Starting Member
9 Posts |
 Posted - 2014-07-17 : 04:09:51
|
| I am doing some research on backup and restoring databases on SQL Server 2012.If I perform a full backup on database which contains a user called A. Following the backup the database user A is removed from the database. If I restore the database will user A be restored with the backup?And what will happen if the backup is performed without the user, the user is added and then the restore is done. Will the database user disappear because they have not been backup? |
|
|
Shanky
Yak Posting Veteran
84 Posts |
Posted - 2014-07-17 : 07:27:19
|
quote:
Originally posted by system243trd
I Following the backup the database user A is removed from the database. If I restore the database will user A be restored with the backup?And what will happen if the backup is performed without the user, the user is added and then the restore is done. Will the database user disappear because they have not been backup?
A backup restore always restores the USER present in database but the LOGINS are not restored. If you restore backup you WILL restore user there is no option of selectively not restoring user while doing restore this all assuming user is present while backup completed. Logins either needs to be created on destination and mapped to user or just simple mappin needs to be done after restore.Below link will give you more infohttp://msdn.microsoft.com/en-gb/library/ms175475.aspxHope this helpsRegardsShankyhttp://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx |
 |
|
|
|
|
|
Backup and Restore Databases