>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