Timeline for How to restore/create linked server logins from one server to another [closed]
Current License: CC BY-SA 4.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 25, 2018 at 13:58 | history | closed |
Tom V Md Haidar Ali Khan mustaccio John K. N. MDCCL |
Needs details or clarity | |
| Oct 24, 2018 at 19:38 | comment | added | oyeesh | This is the situation: 1. I have a job that creates backup files for each DataBase on server A and dumps into remote file storage. 2. I have another job that utilizes these backup files to create Databases on the specified server B. And that could be Sql server running on a docker container too. 3. In job 1 if I could somehow generate a script that has all the linked server logins etc and dump that too in the file storage, I would be able to use that file in job 2. Is there a good way that you can suggest to achieve this? | |
| Oct 24, 2018 at 18:40 | review | Close votes | |||
| Oct 25, 2018 at 13:58 | |||||
| Oct 24, 2018 at 18:29 | comment | added | Tom V | yes I don't understand what you mean by that comment. What problem are you trying to avoid? | |
| Oct 24, 2018 at 18:26 | comment | added | oyeesh | @TomV Thank you for the reply. I could definitely do that. But I want the script to reside in a remote file storage. Reason: I don't want server B(does not contain logins) to depend on Server A(has the login info) every time I restore each database from backup files. Let me know if I can explain better. | |
| Oct 24, 2018 at 18:20 | comment | added | Tom V | Hi, Welcome to the site. Why can't you just script the linked server and the logins and execute it after the restore? Is there any problem with that I'm missing? | |
| Oct 24, 2018 at 17:23 | answer | added | Kin Shah | timeline score: 1 | |
| Oct 24, 2018 at 17:20 | review | First posts | |||
| Oct 24, 2018 at 18:20 | |||||
| Oct 24, 2018 at 17:18 | history | asked | oyeesh | CC BY-SA 4.0 |