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 |
|
info999
Starting Member
4 Posts |
 Posted - 2011-03-17 : 09:08:10
|
| I have successfully copied two small databases hosted online using the database copy tool.However a third database fails to copy. It is what I would consider to be a large database (146MB and 90MB files) which could be part of the problem??The copy database process starts OK and runs for a few minutes. It then fails with the message '"The job failed. Check the event log on the destination server for details"'The events log has the error 'DCOM was unable to communicate with the computer WINDOWSDB using any of the configured protocols.' I assume the WINDOWSDB to be the online server . It is not my computer.Any ideas please why small databases work and the large one fails.Thanks |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2011-03-17 : 09:30:15
|
i'd not use the db copy wizard. more reliable is backup/restore. that is:1. create a backup of the db on server12. copy the .bak to server2 using xcopy or fastcopy or robocopy or some other method3. restore on server2
elsasoft.org |
 |
|
|
|
|
|
problem copying a database