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 |
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
 Posted - 2002-09-18 : 13:37:41
|
| I have a dts task that is scheduled to import data from an access database every 15 minutes.The dts package is working fine however sql server has stopped running it an it tells me the error is that the transaction log is full and needs backup. I have backed up the transaction log and still I get the same error.Can anyone help. |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-09-18 : 13:55:28
|
| You could set your log to autogrow.Are you out of diskspace?-Chad |
 |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-09-18 : 14:04:36
|
| Disk space is good but how do I keep the log under control.I have a dts process that imports approximately 50,000 records every 15 minutes.I need to get database backups working again.Edited by - ValterBorges on 09/18/2002 14:11:30 |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-09-18 : 14:12:24
|
| You can either set the recovery mode to simple, or perform Log backups more often.-Chad |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-09-18 : 14:30:22
|
| What is the easiest way to perform a log backup from a dts package?How would I go about setting up simple recovery.I'm decent with T-SQL and SQL but when it comes to admistration I have a lot to learn.Edited by - ValterBorges on 09/18/2002 14:31:41 |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-09-18 : 14:36:51
|
| I'm assuming this is SQL 2000.Right click the DB->Properties->Options, Change recovery mode from Full to simple.Warning, this will invalidate all your T-Log backups. So if you rely on T-Log backups, this is not a good idea.If you do utilize TLog backups, just schedule a TLog backup to run right after your DTS package. It doesn't have to be part of the same package.-Chad |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-09-18 : 14:57:44
|
| Could you give me some clues as how to have run right after the dts package finishes or do I have to estimate the amount of time it will take.I have to use Full Recovery because I need the ability to recover to any point in time.Edited by - ValterBorges on 09/18/2002 15:02:12 |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-09-18 : 15:03:03
|
| You could alter the job that runs your DTS package, and add a step that backs up the log.-Chad |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-09-18 : 18:07:58
|
| Thanks |
|
|
|
|
|
|
Job Failing Due To Transaction Log (Help)