5 pts.
 SQLServer2005 CopyDatabase Wizard error
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

Software/Hardware used:
ASKED: July 14, 2008  3:26 PM
UPDATED: July 18, 2008  1:05 AM

Answer Wiki:
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.
Last Wiki Answer Submitted:  July 18, 2008  1:05 am  by  Ritchie1   210 pts.
All Answer Wiki Contributors:  Ritchie1   210 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

 64,505 pts.