(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. I have no idea whether I need to detach the database before I copy it. Now I still can’t get success.The detail error messages that like this: "Try to detach the database db_name statusk 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)". Just now I tried to copy the database with replicate Database wizard again,and I also referred to the article that satya showed. Hi, Fisrt I want to thanks the guys whom helped me.
Thanks for your replys,I will try to do it~ Instead of using DTS you could just backup the database and restore it on SQL 2000 or detach/attach the database. And for the copy to work I think no users can be in the database during the copy process. Make sure that the involved server can rach eachother by odbcping. 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) PackageStep Error Description:Step Error code: 80004005Step Error Help Fileqldts80.hlpStep Error Help Context ID:1100" Please help me. SQL Server Performance Forum – Threads Archive SQL Server error :80004005
0 kommentar(er)
