none
Copy Database Wizard problem RRS feed

  • 問題

  •  

    i use the sql 2005 sp2 run the Copy Database Wizard to copy the old sql 2k database to the new sql 05

    but when it execute sql server agent job status error.

    how can solve this problem?

    thank

    2008年7月19日 上午 03:25

解答

  • Use backup/restore instead, copy database wizard never work properly.

     

    2008年7月19日 下午 04:24
  • I think it would be better if more information can be provided.

    Would you please post the error messages that can be obtained from the SQL Server error log?

     

    What are the OS configurations and SQL Server configurations?

    Are your SQL Servers installed on the same OS?

    Have you enabled the TCP/IP protocol on your SQL Server box?

    Is your SQL 2005 database a named instance? If yes, make sure that SQL Server browser service is started.

    Have you enabled Windows Firewall? (Exceptions that may be required: sqlserver.exe, sqlbrowser.exe)

    2008年7月23日 下午 01:06

所有回覆

  • Use backup/restore instead, copy database wizard never work properly.

     

    2008年7月19日 下午 04:24
  • I think it would be better if more information can be provided.

    Would you please post the error messages that can be obtained from the SQL Server error log?

     

    What are the OS configurations and SQL Server configurations?

    Are your SQL Servers installed on the same OS?

    Have you enabled the TCP/IP protocol on your SQL Server box?

    Is your SQL 2005 database a named instance? If yes, make sure that SQL Server browser service is started.

    Have you enabled Windows Firewall? (Exceptions that may be required: sqlserver.exe, sqlbrowser.exe)

    2008年7月23日 下午 01:06