SQLServer2005 CopyDatabase Wizard error

5 pts.
Tags:
CopyDatabase Wizard
SQL Server 2005
Using the CopyDatabase wizard to copy from one SQLServer2005 server to a new SQLServer2005 server node, I got an error in the <Configure the Package> step, that says: "While trying to find a folder on SQL an OLE DB error was encountered with error code 0x80004005 (Login timeout expired)". Please tell me how I can solve and get this wizard to work right. Thanks. Tito Taganajan ttaganajan@hotmail.com
ASKED: July 14, 2008  3:26 PM
UPDATED: July 18, 2008  1:05 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Try restore from backup. Create a new backup and then restore it to new location / or as a new name, to build a new database. I find this has the least problems. If it is to different server copy the backup file to the server first, then restore from it.

The copy database wizard often has errors especially with larger more complex databases.

In this case I would assume that the server name was entered incorrectly or there is a firewall issue between the server and the machine you are running the wizard on.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following