Our database server has been used for more than 5 years and we plan to upgrade..
Currently we have lots databases inside the database server and many jobs running daily. But we have no idea on how to backup/copy all the SQL jobs to the new database server.
Kindly advise any way to upgrade the database server without losing any db, views and sql jobs?
**Currently alot of sql jobs running to update the views in order to generate the business reports.
View Complete Post