Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-05-06 : 08:06:39
|
| Hari writes "I have the complete back up of around 200+tables in each .DAT file generated out of a BCP QUeryout statement. Some of the table size is like 200MB! Now when i started the BCP IN to transfer it to my current new database, the log file has grown to 6120MB! (Originally given size was : 300MB) and the data file size was at 2500MB! The overall Hard disk size is 9GB! With the complete data pumped in to the database with the BCP IN statements, the overall DB size shows to be approxiamately 8.4 GB. The main problem now is that I'm not able to do any inserts aor any other operation on that database! The remaining space left is 10MB only! Can i do something about it? Is there a way i can stop the LOG File growing? I'm surprised to see why the log file has grown from 300MB-->6.1GB, while data file size reamined same as before!I plan to drop the database and re create it all over again. But how can i stop the log file from growing? Is this a problem realted to log files and in general with BCP? Will TABLOCK help me? Thanks in advance.-Hari" |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2003-05-06 : 08:22:09
|
| From BOL:When using the full recovery model, all row-insert operations performed by bcp are logged in the transaction log. For large data loads, this can cause the transaction log to fill rapidly. To help prevent the transaction log from running out of space, a minimally logged bulk copy can be performed if all of these conditions are met: The recovery model is simple or bulk-logged.The target table is not being replicated.The target table does not have any triggers.The target table has either 0 rows or no indexes.The TABLOCK hint is specified. For more information, see "Controlling the Locking Behavior". HTHFranco |
 |
|
|
|
|
|
BCP IN is making my Log file big