Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Backing Up Sql Databases
Message
De
09/04/2007 23:14:05
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01213442
Message ID:
01213782
Vues:
12
>His comments read as though using the agent and backing up to file are mutually exclusive, which is misleading. I've backed up to file using a maintenance plan or SQL Server Agent quite a bit. In fact, that's about the only way I've ever done it. As stated before, the backups are then copied to tape as part of the general server backup.

I didn't read it that way.

>
>He didn't really address the value of software, such as Backup Exec, which can backup the live database files just as the SQL Server's internal backup does. I just don't see the value in having that since you already have that built in to SQL Server (which I think allows you to send it directly to tape as well, although I've never done it that way). Or is there some other angle to this that I am missing?

He does address agents, saying that people generally set them up wrong. The advantage of something like Backup Exec with an agent is that you can have a single backup mechanism for SQL Server and the rest of the files on the server.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform