Problem Using Copy Database Wizard in SSMS

I am having a problem copying a database on a server back to the same server
from a remote computer using SSMS. I have 2 remote computers (WinXP) running
SSMS on the same domain as the server. I log in as an administrative user on
both, but can only run the Copy Database Wizard successfully from one of the
remote computers.
On the computer that fails, it does so at the Create Package step and
returns an error message saying "No description found". Anyone have an idea
how I should begin troubleshooting this problem? I can not find anything in
the event logs on the remote system or server that sheds a clue, or in the
SQL server logs.
Don Sivitz (DonSivitz@.discussions.microsoft.com) writes:
> I am having a problem copying a database on a server back to the same
> server from a remote computer using SSMS. I have 2 remote computers
> (WinXP) running SSMS on the same domain as the server. I log in as an
> administrative user on both, but can only run the Copy Database Wizard
> successfully from one of the remote computers.
> On the computer that fails, it does so at the Create Package step and
> returns an error message saying "No description found". Anyone have an
> idea how I should begin troubleshooting this problem? I can not find
> anything in the event logs on the remote system or server that sheds a
> clue, or in the SQL server logs.
That's not an error that I've seen. Which method are you trying to use?
Direct copy of the files, or the SMO method?
There is a CTP of SP2 out, and Microsoft claims that there are a lot of
fixes to the Copy Database Wizard. I have not tested it myself, though,
yet. I don't really want to recommend you to install beta software, but
if you are desperate you can try it.
However, there plenty of other ways of achieving what the wizard does,
so you may want to explore those options instead.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx