Probem in using the Copy Database wizard

Probem in using the Copy Database wizard

• Rocket Rick

  Any answer for this problem

  Thanks.

  
  
  

• ScottEye

  Another problem is NetBIOS.

  My dev server is on a different subnet to the prod server and because SQL2k5 still insists on using netbios names, it failed all the time; yes I did try specifying FQDN and raw IP, it kept converting it back all the time.

  After adding the netbios name/IP to lmhosts the problem fixed itself up nicely. If anyone knows a better (or proper) way of doing that, feel free to post :)

  Of course now I am having a problem getting the logins to copy (works fine if I dont). Time to scour the Interweb once more :)

  
  

• Daniel Chait

  Dear,

  I use the SQL Management Object method and receive the following error when using the Copy Database wizard:

  Event Name: OnError
  Message: ERROR : errorCode=0 description=Invalid column name 'Date'. helpFile= helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}
  StackTrace: at Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer()
  at Microsoft.SqlServer.Management.Smo.Transfer.TransferData()
  at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.TransferDatabasesUsingSMOTransfer()
  Operator:
  Source Name:
  Source ID: {48880C1D-5BDA-482C-B769-C1985A063347}
  Execution ID: {A9A772F2-6765-45AF-826B-9B5198930549}
  Start Time: 9/25/2007 9:08:59 AM
  End Time: 9/25/2007 9:08:59 AM
  Data Code: 0

  Thanks.

  
  
  

• ETricotti

  Let us know if you are using Attach/ Detach method or SMO transfer

  Could you please post the exact error message . Please make sure that SQL Agent was started and running before you copy a database using Copy database Wizard

  Thanks

  Sethu

  --
  This posting is provided "AS IS" with no warranties, and confers no rights.
  Use of included script samples are subject to the terms specified at
  http://www.microsoft.com/info/cpyright.htm.

  
  

• Zahid Saleem

  I also have the same issue and I am using the Attach/Detach method. I also have SQLServiceAgent Service Started and Automatic. It still fails on the last step.

  In addition, I would like to know how I can delete the saved SSIS package that the Copy Database Wizard has created. I also want to know how to modify it but since I can't get to it, I can't modify it.

  I can see the job and according to the information that the job has given me the

  Package Source: SQL Server

  Package Location: Server/Instance \ DTS Packages \ Copy Database Wizard Packages\ Name of Package

  I greatly appreciate any assistance you can extend to me.

  Thanks,

  Lorenzo

  
  
• Probem in using the Copy Database wizard