• almirfiorio - Wednesday, February 7, 2018 6:34 AM

    NorthernSoul - Wednesday, February 7, 2018 5:50 AM

    almirfiorio - Wednesday, February 7, 2018 5:41 AM

    NorthernSoul - Wednesday, February 7, 2018 5:19 AM

    Which objects have not been restored? You can bring the logins across using sp_help_revlogin and as for the jobs you can just script those out.

    Thnanks

    Logins and Jobs

    how im can use this script? can send me script and instructions ?

    Google sp_help_revlogin and you will find the script and instructions for how to use it. You will execute it on your source and it will produce a script of the logins to run on your target.

    As for the jobs you can right click on the job and 'script job as'.

    Thanks

    As for the jobs you can right click on the job and 'script job as'.

    how im can do that ?

    In management studio expand the Jobs tree under SQL Server Agent--> Right click on the job you want to script out-->Script Job As-->Create to-->Then select where you want the save/send the script for creating the job

    Thanks