Bcp in question Ask you : experts I have derived database using bcp out, but into another loom, when he failed. As much as is possible, resulting log full. Table for certain how many records out in, and hard to get. Thank you! Delete Index No better way? Bcp into support groups? Wait. . . . . . . . . . . . Parameters used-b support ah If bcp. . . . . -b500 Using bcp. . . . - B parameters that would not result in full log phenomenon? Please enlighten master, thank you! ! ! ! Bcp bcp-b parameters can be used in dealing with the record after a certain number of firms to submit data, not submitted to the final. But still rely on ' Truncate log on chkpoint 'constant screening database log database option. Log would lead to full or otherwise. Table delete the directory and the main key for another bcp in, and after re-establishing the main bond index is relatively better solution Into batches and then keep the money log, huh, huh Set up database automatically log removal How to set up log automatically deleted. Under what circumstances would automatically delete the log. Top up, waiting. . . . . . . . . . Reply to the message floor lwygrx Use sp_dboption "trunc log on chkpt" true open database automatically log removal option, so check point for the database, log will be removed. bcp can be used F (firstrow) L (lastrow) to be designated into bcp in the article from a few to several data How to set up log automatically deleted. Under what circumstances would automatically delete the log, said earlier the index to delete what should we do. I greenhorn ah, please exhibitions. : Oops : 1, bcp.bat 2, log.sql 1, Bcp. . . . . . . . F 1-S-P -L3000000 U-series dating method Isql -Uname -Sservername -Ppassword -i log.sql Bcp. . . . . In. . . P-S-F 3000001 -L6000000 U-series dating method Isql -Uname -Sservername -Ppassword -i log.sql     .....     ..... 2, Isql U-series dating method P-S Dump truncate db with only truncate Go Truncate the log can lead to log on chkpoint installed after the space age, after-b numerical increase for 1000 of a submission [ Closed window ]