Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-12-11 : 08:03:40
|
| Jim writes "Hello,I'm having trouble with the "Copy Database Wizard" in SQL Server. After extensive searching I still can't find any information on a solution.I have two computers with SQL Server which belong to a Workgroup and are not in a domain (which isn't practical for my setup). Both SQL Servers log into indentical windows accounts -- that is, the same administrative account on each computer and with the same password; and both are given the same full sysadmin access in SQL Server. Using these logins, I can copy files back and forth between the computers with the cmd.exe command prompt using copy and xcopy without a problem. But when I run the Copy Database Wizard, I get the following error:Failed to copy file \\Computer_Name\OMWWIZd\sqlserver\MSSQL\data\pubs.mdfHere is more information from the log:Step Error code: 80004005Step Error Help File:sqldts80.hlpStep Error Help Context ID:1100Task Log for this step:-----Start Task Log-----Error = 1 (00000001), Description = Successfully created the share OMWWIZDError = 1 (00000001), Description = Begin to copy the database pubsError = 1 (00000001), Description = Database pubs has no active connections.Error = 1 (00000001), Description = Put the database pubs in single user modeError = 1 (00000001), Description = Try to detach the database pubsError = 1 (00000001), Description = Successfully detached the database pubsError = 0 (00000000), Description = Failed to copy file \\Computer_Name\OMWWIZd\sqlserver\MSSQL\data\pubs.mdfError = 1 (00000001), Description = Successfully attached the database pubs on sourceError = 1 (00000001), Description = Successfully deleted the share OMWWIZD-----End Task Log-----Can anyone suggest other things to look at or try? I have also used both Windows authentication and SQL Server authentication and receive the same results.Thanks,Jim" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-12 : 12:29:31
|
| Other things to try:Don't use copy wizard, use detach/attach or backup/restore methods. These have been discussed at length here, so do a forum search for more information.Tara |
 |
|
|
|
|
|
|
|
Failed to copy file when using "Copy Database Wizard"