Navigacija
Lista poslednjih: 16, 32, 64, 128 poruka.

Backup SQL Job-ova

[es] :: MS SQL :: Backup SQL Job-ova

[ Pregleda: 4378 | Odgovora: 3 ] > FB > Twit

Postavi temu Odgovori

Autor

Pretraga teme: Traži
Markiranje Štampanje RSS

caplja caplja

Član broj: 1637
Poruke: 87
*.ftn.ns.ac.yu.



Profil

icon Backup SQL Job-ova06.10.2005. u 16:47 - pre 178 meseci
Kako da backup-ujem SQL Jobs-ove i Logins-e na bazi ? Mislio sam da li je dovoljno da backup-ujem msdb i da je posle samo restore ali mi javlja gresku "the backup of the system database on device c:\msdb cannot be restored because it was create by the different version of the server (neki brojevi) than this server (neki brojevi).
 
Odgovor na temu

m.m.milos
Beograd

Član broj: 124447
Poruke: 3
217.24.24.*



Profil

icon Re: Backup SQL Job-ova08.12.2006. u 13:20 - pre 164 meseci
Za Job-ove, je najbolje da ih skriptujes i pustis na ciljnom serveru. Idi u EM -> Jobs pa selektuj sve jobove koji ti trebaju -> desni klik -> All Tasks -> Generate SQL script. Skript snimis u neki fajl koji posle pustis da se izvrsi na ciljnom serveru.

Za logine nema (koliko ja znam) slicna fora. Eventualno da se pozabavis tabelom sysxlogins u Master bazi. Tamo su svi logini.
Milos
 
Odgovor na temu

m.m.milos
Beograd

Član broj: 124447
Poruke: 3
217.24.24.*



Profil

icon Re: Backup SQL Job-ova08.12.2006. u 13:22 - pre 164 meseci
Za Job-ove, je najbolje da ih skriptujes i pustis na ciljnom serveru. Idi u EM -> Jobs pa selektuj sve jobove koji ti trebaju -> desni klik -> All Tasks -> Generate SQL script. Skript snimis u neki fajl koji posle pustis da se izvrsi na ciljnom serveru.

Za logine nema (koliko ja znam) slicna fora. Eventualno da se pozabavis tabelom sysxlogins u Master bazi. Tamo su svi logini.
Milos
 
Odgovor na temu

dekibre
Dejan Mladenovic
Oslo, Norveska

Član broj: 21820
Poruke: 246
82.208.195.*

Sajt: dekibre.on.w802.net/index..


+4 Profil

icon Re: Backup SQL Job-ova10.12.2006. u 01:00 - pre 164 meseci
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)
 
Odgovor na temu

[es] :: MS SQL :: Backup SQL Job-ova

[ Pregleda: 4378 | Odgovora: 3 ] > FB > Twit

Postavi temu Odgovori

Navigacija
Lista poslednjih: 16, 32, 64, 128 poruka.