September 13, 2013 at 2:04 pm
Hi,
I have restored a backup from server A to server B.
After restoring I found that broker enabled and trustworthy was set to true on server A and not on server B.
I manually set them to true.
I also checked CLR.
Are there any additional things that we need check that will not be done with restoring?
Thanks.
September 13, 2013 at 3:53 pm
If you have users defined from SQL logins, they may not map to SQL logins on the new servers. Mapping is on SID, so even if there is a login Nisse on both servers, the database user Nisse may not map to the login Nisse on server B.
Beware that the Trustworthy option is a potential security hole. If everyone who is db_owner in that database are also sysadmin, there is no issue, but else it can be used to elevate your privledges.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply