Home Forums Database Design Disaster Recovery How to sync linked server, jobs, alerts, logins, etc to a secondary serveur RE: How to sync linked server, jobs, alerts, logins, etc to a secondary serveur
SQLBuddy123
One Orange Chip
Points: 28294
More actions
April 4, 2014 at 8:15 am
#1703320
Those objects have to created only once. Just script them out and create them on the DR server.
Regarding system dbs, just copy any user objects that were created in those DBs.
--
SQLBuddy