Hi,

I got something similar, but during the night process, so I am doing FULL backup before data migration, changing db to SIMPLE, importing all stuff,changing back to FULL, and backup....

Hi,

did you check the file? collations....maybe there some junk or invalid characters? I had some problems with bcp - files format, files data, separators, new lines, format files...Try to break...

Hi Paul,

I am just guessing... Try to play with connections and authentication, make it mixed (windows and SQL), refresh everything, create new connections... Something is there just not finding each other... Create...

I don't think there is anything to do with the space, it says "of either a thread exit or an application request" - something interrupted your backup...Can it be another...

put SP and other stuff on the couple disks and show to couple users how to do this and just go one by one, I had to do something similar,...

hmm...I got the same, but there was something else :

New log file 'd:\MSSQL\Data\TEST_log.LDF' was created and the database was attached...

I am thinking - I got once the database was detached...

p johnson, you are saying "the one fix - to reset db connectionfrom their end".... can it be something is going on on their side? and connection is breaking...sounds like...

mkeast!!! You made my day!!!WOW!!!

it worked!

It says in BOL:

Allows the user to set the screen width for output. The default is 80...

One more: when I ran that SP into Report (in QA) and saved as .rpt file - everything went out GREAT! all command lines are good and no cuts. HOW...

I changed to 8000 - the same output. I thought about OSQL limitations, maybe it's the output something...limit... can not find any option or property to modify it

Using the cursor the SP is printing for me all command lines for every database I have, then I am just running this printed output as SP.

CREATE Procedure SP_AttachDB2Drives

as

declare @name varchar(50)

declare @file varchar(100)

declare @log varchar(100)

Declare @SQL varchar(200)

Declare @sp-2 varchar(200)

Set @sp-2 = 'CREATE  Procedure Databases_Attach2Drives @datadrive char(1), @LogDrive char(1)

as

Declare...

No, files are deleted daily, but the one which is 1 week old only.

I had couple times the "append" happened (have no idea why) and the backup file was...

Maybe sometimes (as you told it happened not every time) the records from Lotus notes ate too long or the previous DTS overloaded memory and it can not read it...

I found this in BOL :

 Microsoft OLE DB Provider for Access buffers all inserts in memory and only commits them when the DTS Import/Export Wizard completes operation. As a result,...