I was trying to copy a database of about 200MB in size from source
server to destination server, with a log file of around 5GB.

I received a error message after I started executing with the Copy
Database Wizard in SQL Server Management Studio. Part of the error
message from log file is posted below.

OnInformation,DestinationServer,DestinationServer\ Administrator,SourceServer_DestinationServer_Trans fer
Objects
Task,{AFFDEF09-37B1-472C-BCB2-157D0481E17B},{498CAA3A-00FA-4D66-AE93-34353454682D},6/7/2006
5:28:02 PM,6/7/2006 5:28:02 PM,0,0x,CREATE DATABASE
[MarketingDataWarehouse] ON PRIMARY
( NAME = N'MarketingDataWarehouse_Data', FILENAME = N'C:\Program
Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\MarketingDataWarehouse_D ata_new.MDF' , SIZE =
237248KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
LOG ON
( NAME = N'MarketingDataWarehouse_Log', FILENAME = N'C:\Program
Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\MarketingDataWarehouse_L og_new.LDF' , SIZE =
4632576KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
OnInformation,DestinationServer,DestinationServer\ Administrator,CDW_SourceServer_DestinationServer_1 1,{B320352E-E25B-4EBA-AA58-02065FF4DB5E},{498CAA3A-00FA-4D66-AE93-34353454682D},6/7/2006
5:28:02 PM,6/7/2006 5:28:02 PM,0,0x,CREATE DATABASE
[MarketingDataWarehouse] ON PRIMARY
( NAME = N'MarketingDataWarehouse_Data', FILENAME = N'C:\Program
Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\MarketingDataWarehouse_D ata_new.MDF' , SIZE =
237248KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
LOG ON
( NAME = N'MarketingDataWarehouse_Log', FILENAME = N'C:\Program
Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\MarketingDataWarehouse_L og_new.LDF' , SIZE =
4632576KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
OnError,DestinationServer,DestinationServer\Admini strator,SourceServer_DestinationServer_Transfer
Objects
Task,{AFFDEF09-37B1-472C-BCB2-157D0481E17B},{498CAA3A-00FA-4D66-AE93-34353454682D},6/7/2006
5:38:03 PM,6/7/2006 5:38:03 PM,0,0x,An exception occurred while
executing a Transact-SQL statement or batch.
StackTrace: at
Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteWithResults(String
sqlCommand)
at
Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteWithResults(StringCollection
sqlCommands)
at
Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask. TransferObjectsTask.TransferDatabasesUsingSMOTrans fer()
InnerException-->Timeout expired. The timeout period elapsed prior to
completion of the operation or the server is not responding.
CREATE DATABASE failed. Some file names listed could not be created.
Check related errors.
StackTrace: at
System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream,
BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaDat a()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at
System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString)
at
System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean
async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String
method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String
method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior
behavior, String method)
at
System.Data.SqlClient.SqlCommand.ExecuteDbDataRead er(CommandBehavior
behavior)
at
System.Data.Common.DbCommand.System.Data.IDbComman d.ExecuteReader(CommandBehavior
behavior)
at System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at
Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteWithResults(String
sqlCommand)
OnError,DestinationServer,DestinationServer\Admini strator,CDW_SourceServer_DestinationServer_11,{B32 0352E-E25B-4EBA-AA58-02065FF4DB5E},{498CAA3A-00FA-4D66-AE93-34353454682D},6/7/2006
5:38:03 PM,6/7/2006 5:38:03 PM,0,0x,An exception occurred while
executing a Transact-SQL statement or batch.
StackTrace: at
Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteWithResults(String
sqlCommand)
at
Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteWithResults(StringCollection
sqlCommands)
at
Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask. TransferObjectsTask.TransferDatabasesUsingSMOTrans fer()
InnerException-->Timeout expired. The timeout period elapsed prior to
completion of the operation or the server is not responding.
CREATE DATABASE failed. Some file names listed could not be created.
Check related errors.
StackTrace: at
System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream,
BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaDat a()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at
System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString)
at
System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean
async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String
method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String
method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior
behavior, String method)
at
System.Data.SqlClient.SqlCommand.ExecuteDbDataRead er(CommandBehavior
behavior)
at
System.Data.Common.DbCommand.System.Data.IDbComman d.ExecuteReader(CommandBehavior
behavior)
at System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at
Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteWithResults(String
sqlCommand)
OnProgress,DestinationServer,DestinationServer\Adm inistrator,SourceServer_DestinationServer_Transfer
Objects
Task,{AFFDEF09-37B1-472C-BCB2-157D0481E17B},{498CAA3A-00FA-4D66-AE93-34353454682D},6/7/2006
5:38:03 PM,6/7/2006 5:38:03 PM,0,0x,Database transfer is complete.
OnProgress,DestinationServer,DestinationServer\Adm inistrator,SourceServer_DestinationServer_Transfer
Objects
Task,{AFFDEF09-37B1-472C-BCB2-157D0481E17B},{498CAA3A-00FA-4D66-AE93-34353454682D},6/7/2006
5:38:03 PM,6/7/2006 5:38:03 PM,100,0x,Transfer objects finished
execution.
OnPostExecute,DestinationServer,DestinationServer\ Administrator,SourceServer_DestinationServer_Trans fer
Objects
Task,{AFFDEF09-37B1-472C-BCB2-157D0481E17B},{498CAA3A-00FA-4D66-AE93-34353454682D},6/7/2006
5:38:03 PM,6/7/2006 5:38:03 PM,0,0x,(null)
OnWarning,DestinationServer,DestinationServer\Admi nistrator,CDW_SourceServer_DestinationServer_11,{B 320352E-E25B-4EBA-AA58-02065FF4DB5E},{498CAA3A-00FA-4D66-AE93-34353454682D},6/7/2006
5:38:03 PM,6/7/2006 5:38:03 PM,-2147381246,0x,The Execution method
succeeded, but the number of errors raised (1) reached the maximum
allowed (1); resulting in failure. This occurs when the number of
errors reaches the number specified in MaximumErrorCount. Change the
MaximumErrorCount or fix the errors.

OnPostExecute,DestinationServer,DestinationServer\ Administrator,CDW_SourceServer_DestinationServer_1 1,{B320352E-E25B-4EBA-AA58-02065FF4DB5E},{498CAA3A-00FA-4D66-AE93-34353454682D},6/7/2006
5:38:03 PM,6/7/2006 5:38:03 PM,0,0x,(null)
PackageEnd,DestinationServer,DestinationServer\Adm inistrator,CDW_SourceServer_DestinationServer_11,{ B320352E-E25B-4EBA-AA58-02065FF4DB5E},{498CAA3A-00FA-4D66-AE93-34353454682D},6/7/2006
5:38:03 PM,6/7/2006 5:38:03 PM,1,0x,End of package execution.


Is there any workaround for this? Should I set the timeout parameter to
a higher value? And if so, how?

Will appreciate any information on this issue. Thanks!