Ako želiš da uradi transfer jobova i logina na drugi server onda postoji sledeća varijanta:
Za transfer jobova možeš koristiti DTS (a možeš i da ih skriptuješ kako je preporučeno u prethodnom postu)
pod uslov da ti se oba servera medjusobno "vide"
Transfer Jobs using DTS
REMARKS
Remember that you will get a warning if any GO statements are used within your Transact-SQL
steps. Remove them temporarily (or comment them out) prior to scripting. You can also choose a
different batch separator, such as MYBATCH, or a word that is meaningful to you, and then modify
the batch separator temporarily in Query Analyzer. To do this, in Query Analyzer, select the Tools
and Options menu. Select the Connections tab, and change the Batch separator value from GO to
your new batch separator. Make sure to change this back to GO when finished compiling the script:
TRANSFER JOBS USING DTS
-- In Enterprise Manager, expand the server group and server registration.
-- Expand the Data Transformation Services folder.
-- Right-click the Local Packages node and select New Package.
-- In the DTS Package Designer, go to the Task menu and select Transfer Jobs Task…
-- In the Transfer Msdb Jobs Property dialog box enter the source server and method for connection,
Windows authentication or SQL Server authentication.
-- Select the Destination tab and select the destination server for your jobs, as well as connection method.
-- Select the Jobs tab. In the Job Copy Option, select whether you wish to transfer all jobs or selected
jobs. If selected jobs, check the jobs you wish to transfer after switching the option bullet to Selected
jobs. Select OK when finished:
-- Go to the Package menu and select Execute.
-- You should see the transfer in progress, and then the success dialog box.
Check the destination server to make sure the jobs were created. You can save the DTS package if
you plan on transferring the jobs again, or can exit and say 'No' to saving the package.
A za transfer logina pročitaj sledeći link
How to transfer logins and passwords between instances of SQL Server
Posebno obrati pažnju da li su logini SQL ili Windows i da li su ti SQL serveri na istom domenu ili različitom.
You can fool some people sometimes,
But you can't fool all the people all the time. (Bob Marley)
Backup SQL Job-ova
