SQL Server Performance Forum – Threads Archive
SQL Server error :80004005Hi,all,<br /> I want to copy one while database from Sql server 7.0 to SQL Server 2000,<br />and I used replicate Database wizard to do it,but i got some error messages that like this:<br />"Step Error Source: Microsoft Data Transformation Services (DTS) Package<br />Step Error Description:<br />Step Error code: 80004005<br />Step Error Help File<img src=’/community/emoticons/emotion-7.gif’ alt=’:s’ />qldts80.hlp<br />Step Error Help Context ID:1100"<br /><br /> Please help me.<br /> Thanks!<br /><br />I want to make more friends~
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,<br /> Fisrt I want to thanks the guys whom helped me.<br /> Just now I tried to copy the database with replicate Database wizard again,and I also referred to the article that satya showed.<br /> Now I still can’t get success.The detail error messages that like this:<br /> "Try to detach the database db_name status<img src=’/community/emoticons/emotion-3.gif’ alt=’:O’ />k;<br /> Can’t detach the database db_name status:fail;<br /> Can’t copy file \Source machine nameOMWWIZEData_sqldb_name_data.mdf status:fail<br /> Cant’ attach the database db_name to the source(server)". <br /> <br /> I have no idea whether I need to detach the database before I copy it.<br /> (But I think if I detach the database first ,I won’t see the database in the Enterprise manager.)<br /><br /> Note:There wasn’t anyone to connect the database.<br /><br /> Help me please,<br /> Thanks so much~ <br /><br /><br />Jelly is here.