>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