Merrily,

I'll get the ball rolling and just bite off a portion of your post by answering your questions.  I've no experience with HP Data Protector.  We use native SQL Server...

Hi Paul,

The Tlog is truncated every time a log backup is taken when a database recovery model is “Full”. 

So, you shouldn’t need to use TRUNCATE_ONLY. ...

NOINIT is a BACKUP argument that preserves any existing backup sets in a backup device.  It's opposite is INIT which will overwrite any existing backup sets.

TRUNCATE_ONLY is a BACKUP LOG...

I must be dumb too.  I had to search for it in MSDN.  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtsprog/dtsppumpif_7b3f.asp

Greg

Remi,

TRUNCATE won't work if a table is referenced by a foreign key constraint, even if the constraint is disabled.  BOL is kind of vague about this, but I've experienced it. ...

Kevin,

Sorry I haven't been able to post for the last couple of weeks.  Did you resolve this problem.  It occurred to me that this may be happening because you granted...

Kasper,

If you're only going to do full database backups, make sure the database recovery model is set to Simple to keep the tlog from growing.

Greg

Hi Alex,

What are the tasks doing in your package and which one fails?  Which other thread are you referring to?

Thanks,

Greg

Kevin,

Try adding internet_user as a user in TTCUserInfo with no permissions.

Greg

That's the only way I've found to do it.

Greg

You can't backup Tempdb anyway.  By design, nothing is permanent in Tempdb and it's recreated whenever SQL Server is started, so there's no point in backing it up. 

Greg

Look at the properties of the connection for the file.  Is the "first row has column names" option checked?  That will make the import skip the first row.

Greg

Create a DTS package that imports the data and updates the SQL Server tables, then schedule the package as a SQL Server job that runs nightly.

Greg

Mike is correct.  Here's the SQL Server licensing site:

http://www.microsoft.com/sql/howtobuy/default.asp

Greg

Paul,

I assume you're running the package manually from your workstation where you have the correct ODBC DSN defined.  When you schedule a package, it runs on the database server which...