General information
Forum:
Microsoft SQL Server
>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only