SQL Server Performance Forum – Threads Archive

SQL Server error :80004005

Hi,all, I want to copy one while database from Sql server 7.0 to SQL Server 2000, and I used replicate Database wizard to do it,but i got some error messages that like this: "Step Error Source: Microsoft Data Transformation Services (DTS) Package Step Error Description: Step Error code: 80004005 Step Error Help File<img src=’/community/emoticons/emotion-7.gif’ alt=’:s’ />qldts80.hlp Step Error Help Context ID:1100" Please help me. Thanks! I want to make more friends~

Referhttp://www.microsoft.com/japan/support/kb/articles/JP305/3/65.asp _________
Satya SKJ

Make sure that the involved server can rach eachother by odbcping. And for the copy to work I think no users can be in the database during the copy process. Instead of using DTS you could just backup the database and restore it on SQL 2000 or detach/attach the database. /Argyle

Thanks for your replys,I will try to do it~ I want to make more friends~

Hi, Fisrt I want to thanks the guys whom helped me. Just now I tried to copy the database with replicate Database wizard again,and I also referred to the article that satya showed. Now I still can’t get success.The detail error messages that like this: "Try to detach the database db_name status<img src=’/community/emoticons/emotion-3.gif’ alt=’:O’ />k; Can’t detach the database db_name status:fail; Can’t copy file \Source machine nameOMWWIZEData_sqldb_name_data.mdf status:fail Cant’ attach the database db_name to the source(server)". I have no idea whether I need to detach the database before I copy it. (But I think if I detach the database first ,I won’t see the database in the Enterprise manager.) Note:There wasn’t anyone to connect the database. Help me please, Thanks so much~ Jelly is here.

]]>