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

  • what do you mean by "If you don't mind using SSIS"? we have just finished to convert from Oracle so we havent had the chance to play with everything in the world of SQL Server. We do know what's the purpose of SSIS but if you ask this question, maybe it is because the tool is not loved by everyone. Is there something i should know? Is it good or is it bad?

    and is there any fullproof ssis package that is ready to transfert everything to the DR server or i should start from scratch?