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-02-11 : 07:12:36
|
| Douglas Spadotto writes "Hello.I run a DTS who deletes all the records from some of my tables and import new content to the tables.The problem is that the log size gets too big. 14 Gb for a 200 Mb database.What's the problem?" |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-02-11 : 08:53:44
|
| What kind of backup scheme do you use?Do you care if the deletes are logged?Can you use another database to perform the import?The problem is that everytime you import it writes everything to the transaction log. If you are doing tlog backups your going to need the extra space but you can aleviate by using another database to import and process the data before placing it in its final destination. If you are just backing up the database once a day then you could also use truncate table instead deleting all records that way there is no logging of deletes.Are you updating every row or only rows that have changed?The second would also cut down on the amount of logging. |
 |
|
|
|
|
|
DTS running daily makes log too big