Timeline for How to maintain database ownership restoring across domains?
Current License: CC BY-SA 3.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 25, 2019 at 13:30 | history | edited | Solomon Rutzky |
edited tags
|
|
| Oct 25, 2019 at 3:54 | answer | added | Solomon Rutzky | timeline score: 1 | |
| Oct 23, 2019 at 20:47 | comment | added | John Eisbrener |
EXECUTE AS LOGIN = 'NewDomain\NewUser' RESTORE DATABASE....
|
|
| Oct 23, 2019 at 20:01 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jun 24, 2019 at 3:18 | comment | added | Dat Nguyen | An advanced option that you'd try: Prepare your script to add db_owner database role for that domain login. Give your script into a trgger INSERT of msdb.dbo.restorehistory; | |
| Jun 23, 2019 at 6:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Feb 21, 2019 at 11:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Nov 24, 2014 at 19:50 | comment | added | armitage | Instead of just replacing the Database can they not script the changes (schema/data) and run the changes on the existing db at your site? | |
| Nov 24, 2014 at 19:38 | history | asked | SomeGuy | CC BY-SA 3.0 |