What to do after importing 500,000 records

[Glowworm27]

Hello all

I had a DTS package that is importing about half a million records every couple days, my question is what do I need to do about the tempdb and the transaction log for my database after the DTS package runs? Anything

The database is currently at 65 GigaBytes, and the Log file is 10 gigs, and the tempdb is 3 gigs.

Do I need to truncate these databases? or shrink them ? before the dts runs again?

thanks for any help


George Oakes
Check out this awsome .Net Resource!

http://www.learnvisualstudio.net?referedby=54275&cam=Tek-Tips

 

[cfaulkner]

Did you ever find your answer. Can't beleive no one answered this one. If you still need help let me know your backup plan and I'll give you some ideas. If you are not doing log backups you can set you DB to avoid this problem. If you are there are still options.

Craig

 

[Glowworm27]

Thank You,

I ended up re-working the DTS package, and managing some indexes. I have it where it is pretty stable now, I re-index the DB on Sunday afternoon when all the store data has been inserted. By re-indexing the DB weekly I have resolved a lot of problems with record inserts, and data retrieval.

All is doing well now, and the DB is currently over 100 Gigs in size, and Growing!!!! one of these days we will need to purge off some of the older data, because it isn't usefull anymore. But Untill then I have maintenace plans working to keep the data in order.

Thanks!

George Oakes
Check out this awsome .Net Resource!

http://www.learnvisualstudio.net?referedby=54275&cam=Tek-Tips

 

[baddos]

yikes.... that is a pretty big log file.

I would maybe look at making another file group and archiving data to archive tables in that file group on a separate RAID system for archiving old.


After doing a full backup, does shrink DB shrink that log file down at all?

 

[Catadmin]

You might want to backup your DB before running this job, then change its Recovery Model (in database properties) to Simple mode. Then run your job, backup the DB again, and change it back to Full mode.

This can be done via T-SQL commands or via Enterprise Manager. If you script it with T-SQL, you can create 2 jobs. One that goes before your DTS job and the second to go after the completion of your DTS job. Then you won't have to monitor it or worry about the size of your Transaction Logs.



Catadmin - MCDBA, MCSA
Beware the error of pre-emptive poultry inventory!