Are there possibly extra control characters in the data that you are trying to BCP? (for example carriage returns and line feeds within a varchar or text field)

I'm not sure that without backing up the log that you could do a point in time restore from an LDF.

How about backing up the entire database, truncating the log,...

Unless you have a Gb backbone I wouldn't even try to dump a 50Gb translog across the network, you'll kill traffic for everyone who's trying to connect into the db.

BTW I wouldn't use the Arcserve agent even if they purchased it.

Yes, sorry, should have been more clear.

I wouldn't use any of the open file or backup software sql agent programs. They backup great, problem is the restore.

If you can live without the log you could

BACKUP LOG <DBNAME> WITH NO_LOG

GO

DBCC SHRINKFILE ('<LOG NAME FROM SYSFILES>', 128, TRUNCATEONLY)

GO

Have you set the on success/completion precedence for both steps in the sqlconn3-->Excelconn3? If you've only sset it to one of them then it would execute when the package started.

Is your database in the full recovery mode? If not you won't be able to do a point in time restore anyhow. The other thing is that you should be...

create table #indexes (index_name sysname, index_description varchar(1000), index_keys varchar(1000))

insert into #indexes exec sp_helpindex <tablename>

If you want a permanent table just change the created table.

If the login already exists on the production box you can fix the association with the user in the database by running (within the db)

sp_change_users_login 'update_one', 'login', 'login'  --where login...

not that I am aware of, it would be great if someone had a solution however

Yuo can also set the new filegroup as default, thereby cause all new objects to be placed there (unless specified differently in the create statement).

We had this before, but I can't remember what you wrote me what Forrest Gump's mom used to say on stupid questions.

Stupid is as stupid does.

Not sure that it's stupid questions...

How would you know which comma is the extra comma?