>>Hello,
>>
>>I'm trying to dublicate one database by exporting data into new database.
>>But I'm getting error, that export failed and in log file there written same lines many times:
>>
::Error::
>>Transfer Status: Transferring Data: (Table '[dbo].[theTable]')
>> Data truncation occurred in table [dbo].[theTable], column 2.
>>What wrong with this table?
>>What I should do?
>>Thanks.
>
>Sounds like the column is not big enough to receive the source data from the original column.
>
>As an alternative, you can use the DTS wizard (Import/Export) to copy all objects from one db to another by selecting "Copy Objects/All Objects". You can save this as a script if you want to run it on a schedule.
>
>HTH
But i was using DTS wizard and it fails! :(
Giedrius