Copy Database Wizard Timeout Error

Hi,

I am copying a database from one server to the other. Both have SQL 2005. When using the CDW, I get the following error after 10 minutes:

Event Name: OnError

Message: An exception occurred while executing a Transact-SQL statement or batch.

StackTrace: at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteWithResults(String sqlCommand)

at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteWithResults(StringCollection sqlCommands)

at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.TransferDatabasesUsingSMOTransfer()

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.

It always errors at 10 minutes. But, when I run the Create Database statement from my query analyzer, it works and it takes about 18 minutes.

How do I get the CDW to wait longer than 10 minutes before returning an error?

I have set my remote query timeout to 20 minutes and that didn't seem to have any effect.

Thanks,

--ExoStatic

Have you installed Service PAck 2? CDW is much improved.

Download SQL Server 2005 Service Pack 2 at:

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx

...probably doesn't matter but the job runs on the destination server so it timeouts are relevent they may need to be set on that server.

|||

We have greatly improved SMO transfer in CDW with Service Pack 2. I strongly suggest you try that. Also, you could try using the detach/attach method instead of SMO Transfer. I believe it is faster and more reliable.

After installing Service Pack 2, please let us know if your problem persists. You may still have to change some settings on your server.

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

|||

if you use Detach/attach method you still need to migrate the Login from Source Server. You can also try Backup/Restore method which is best in such scenario. in this method also the Logins has to be taken care.

To transfer login Refer :http://support.microsoft.com/default.aspx/kb/246133

Madhu

sqlsql