Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
DTS import text file
Message
De
06/07/2005 15:28:17
Keith Payne
Technical Marketing Solutions
Floride, États-Unis
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Divers
Thread ID:
01029651
Message ID:
01029669
Vues:
13
>I'm trying to import data from a huge text file (20G) on a development server with limited disk space and am having problems running out of disk space. I have enough room for the database itself but I believe I'm having problems due to log file growth as data is being imported.
>
>Is there a way to disable logging during import in DTS? TIA.

John,

Try setting the recovery model on the database to 'bulk logged'. AFAIK, this is the same as full logging, except when performing BULK INSERT operations. Check out 'Bulk-Logged Recovery model' in BOL.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform