SQL 2012 database copy between Servers
Posted on 2013-05-10
I am trying to copy databases between two 2012 SQL servers using the CopyDatabase Wizard. My problem occurs when the Wizard is on the "Configure the Package" screen. A timeout error occurs: "While trying to find a folder on SQL...." and then the timeout message.
I can use MMS to connect to both servers without any problems and am using the sa accounts in the Wizard. SQL Server Agent is running on both servers. I have tripled the timeout period.