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.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Backup and Restore Databases

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 info
http://msdn.microsoft.com/en-gb/library/ms175475.aspx

Hope this helps

Regards
Shanky
http://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx
Go to Top of Page
   

- Advertisement -