fajitapete1
MIS
Ned some ideas, when ever I try to use the built in wizard to move/copy a database from one sql server to another it fails with a general error message:
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Unspecified error
Step Error code: 80004005
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:1100
I am logged in to both servers as sysadmin gave myself all the right in the world, but I can not get this thing to work. Any ideas?
What I really want to do is copy the database and use new database, data and log file names. I will continue to do it manually but I would like to know what I am doing wrong.
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Unspecified error
Step Error code: 80004005
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:1100
I am logged in to both servers as sysadmin gave myself all the right in the world, but I can not get this thing to work. Any ideas?
What I really want to do is copy the database and use new database, data and log file names. I will continue to do it manually but I would like to know what I am doing wrong.
