Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Wrong collation sequence
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Installation
Divers
Thread ID:
01034211
Message ID:
01034227
Vues:
28
As a matter of the fact, Jobs and DTS packages are stored in the MSDB dtatabase. You can use free DTSBackup 2000 from http://www.sqldts.com/default.aspx?242 to backup or transfer DTS packages. The Jobs can be scripted from EM.

>
>My question is not at the databases level, I've covered those fields by fields. I'm more concerned about the instance level.
>
>DTS and jobs seems to be stored at the master db level. I'm sure that rebuilding whould drop everything....
>
>I cannot see how to backup those (dts and jobs) since they are part of master.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform