Hi all!

Past few days I tried to find out what is going on, but
without results, so please find some time if you know wjat
is going on here...
SQL Server 7.0 SP 2 NT 4.0 SP6a...
- One database, daily full database backup, backup of
tranasction log each hour during working hours, everything
works fine...
- Few DTS based jobs, simple imports from one to another
table created with DTS exp/imp wizards, everything still
works fine (including all backups)...
- New DTS package with 15 tasks! DTS itself runs fine...
But after its completion, backup of transaction log failes
because of nonlogged updates, it failes and fails up to
the next full database backup. After full database backup,
backups of transaction log runs fine, up to the same DTS
task, and then failes again!

WHAT IS GOING ON?????
PLEASE HELP!!!!!!!!!!
THANKS IN ADVANCE!!!!

In your DTS package are you doing any non-logged operations? Bulk inserts,
truncates can cause you problems and they can be rewritten. Another option
is if you don't want to rewrite the tasks, you could include a backup
database operation as your last task.

HTH

--
Ray Higdon MCSE, MCDBA, CCNA
---
"armin" <arminmu (AT) lsinter (DOT) net> wrote

Hi Ray!
Thank you very much for your post!
This DTS in question is called from one job as a second
step. First step of this job has a truncate table cmd. But
I'm confused with the fact that my other DTSs jobs also
have truncate table in a first step, and they also do a
bulk insert as well as one in question, but they works
fine.
The main diference between these "OK" and "NotOK" DTS
packages are:
-size of tables in question
-"OK" are created through DTS Imp/exp wizard and have only
one task, "NotOK" consists of 15 tasks, each importing
data in one table that is truncated in first step, each
going after succesfuly completed previous one.
Is there any option in task, workflow or package
properties that can help?
How DTS can be rewritten? Truncate can be replaced with
drop then creating that table (delete would be very slow),
but how to rewrite these 15 imports from 15 differnt
servers on quite long-distance locations?

THANK YOU VERY MUCH FOR YOUR TIME!!!

Best regards,

Armin

Perhaps the easiest thing to do would be to issue your full backup after the
package is done, especially if this is done after hours.

--
Ray Higdon MCSE, MCDBA, CCNA
--
"armin" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Hi Ray.

Unfortunatelly, the business procedure does not allow me
to do it, i.e. I have no time for that!

Best regards,

Armin