Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How To Store On Remote Location
Message
De
11/06/2002 19:25:55
Jason Dalio
Northern Interior Regional Health Board
Prince George, Colombie Britannique, Canada
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Copies de sauvegarde
Titre:
How To Store On Remote Location
Divers
Thread ID:
00667147
Message ID:
00667147
Vues:
54
I have a system that does nightly full backups and hourly transaction log backups (SQL 7). Enterprise Manager does not allow you to select network drives as a destination for backups. While this can be accomplished through manually writing stored procedures I do not want to do it because of speed issues. What I am wondering is what methods could be used to transfer the backed up files (as the backups occur) to a remote destination. What I would really like is a way to tap into the name of the file produced by the job (Database Maintenance Planner) and utilze a second step of the job to transfer the file. That way everything is nice and neat and in one place. Also, it would be nice to hear how anyone else has dealt with this same issue. Thanks all.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform