Copy Database Wizard never finishes

I am trying to use the Copy Database Wizard to copy about 240 databases on
Server1 with With SQL Server 2000 to Server2 with SQL Server 2005 64 bit.
The Copy Database Wizard starts and is successfull with the first 4 steps
but the last 5th step never finishes. I have tried moving all of the
databases at the same time. Or Just moving one small database and the Wizard
never finishes with no errors.
Any ideas, am I going about it the wrong way?
Peace in Christ
Marco Napoli
http://www.ourlovingmother.orgHi
It may be easier to backup/restore?
John
"Marco Napoli" <marco@.avantitecnospam.com> wrote in message
news:OKcxeclCGHA.2320@.TK2MSFTNGP11.phx.gbl...
>I am trying to use the Copy Database Wizard to copy about 240 databases on
>Server1 with With SQL Server 2000 to Server2 with SQL Server 2005 64 bit.
> The Copy Database Wizard starts and is successfull with the first 4 steps
> but the last 5th step never finishes. I have tried moving all of the
> databases at the same time. Or Just moving one small database and the
> Wizard never finishes with no errors.
> Any ideas, am I going about it the wrong way?
> --
> Peace in Christ
> Marco Napoli
> http://www.ourlovingmother.org
>|||Don't have that environment to test it or give you specific advice on.
But, you can also move databases from 2000 to 2005 by backup/restore and
detach/attach. BTW, once in 2005, there is no going back to 2000 with a
database as 2005 will automatically upgrade the system tables, etc.
Just a thought,
Joe
"Marco Napoli" wrote:

> I am trying to use the Copy Database Wizard to copy about 240 databases on
> Server1 with With SQL Server 2000 to Server2 with SQL Server 2005 64 bit.
> The Copy Database Wizard starts and is successfull with the first 4 steps
> but the last 5th step never finishes. I have tried moving all of the
> databases at the same time. Or Just moving one small database and the Wiza
rd
> never finishes with no errors.
> Any ideas, am I going about it the wrong way?
> --
> Peace in Christ
> Marco Napoli
> http://www.ourlovingmother.org
>
>|||Marco Napoli (marco@.avantitecnospam.com) writes:
> I am trying to use the Copy Database Wizard to copy about 240 databases on
> Server1 with With SQL Server 2000 to Server2 with SQL Server 2005 64 bit.
> The Copy Database Wizard starts and is successfull with the first 4
> steps but the last 5th step never finishes. I have tried moving all of
> the databases at the same time. Or Just moving one small database and
> the Wizard never finishes with no errors.
Are you using the CDW in SQL 2005? In such case, are you using the
attach/detach method or the SMO method? (I would recommend staying away
from the latter. I filed many bugs for it during the beta programme,
and not all have been resolved.)
As the others have suggested backup/restore may an easier way to go,
rather than relying a on a wizard that you don't know exactly what it's
doing. The one thing you will have to do manually, if you use backup/restore
is to clean up the user-login mapping on the new server.
sp_change_users_login is good for that. (Whether the CDW handles this,
I don't know, but I would expect it to.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||I have tried using the CDW using the attache/detach and the SMO method. Both
gave me the same results, the wizard keeps going.
I am not opposed to do a backup/restore but I am trying to figure out how to
do all of the 240 database in one night. The server can only be down from
10:00 pm until morning. I have not figured out an automated way to restore
all db's from backup and recreate all logins for each db.
Thanks.
Marco
"Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
news:Xns9739481E99ADYazorman@.127.0.0.1...
> Marco Napoli (marco@.avantitecnospam.com) writes:
> Are you using the CDW in SQL 2005? In such case, are you using the
> attach/detach method or the SMO method? (I would recommend staying away
> from the latter. I filed many bugs for it during the beta programme,
> and not all have been resolved.)
> As the others have suggested backup/restore may an easier way to go,
> rather than relying a on a wizard that you don't know exactly what it's
> doing. The one thing you will have to do manually, if you use
> backup/restore
> is to clean up the user-login mapping on the new server.
> sp_change_users_login is good for that. (Whether the CDW handles this,
> I don't know, but I would expect it to.)
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx|||Hi Marco
This sounds like you may be burning your bridges a bit! Do you need to move
all databases at once? Is your time window applicable at wends? Can
existing backup jobs be utilised?
A trial run should give you an idea of timings and will also help you plan
the migration.
Have you checked that the code for your stored procedures/views/functions
are still compatible?
For logins check out:
http://support.microsoft.com/kb/246...122120121120120
John
"Marco Napoli" <marco@.avantitecnospam.com> wrote in message
news:uFlqmVnCGHA.900@.TK2MSFTNGP10.phx.gbl...
>I have tried using the CDW using the attache/detach and the SMO method.
>Both gave me the same results, the wizard keeps going.
> I am not opposed to do a backup/restore but I am trying to figure out how
> to do all of the 240 database in one night. The server can only be down
> from 10:00 pm until morning. I have not figured out an automated way to
> restore all db's from backup and recreate all logins for each db.
>
> Thanks.
> Marco
>
> "Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
> news:Xns9739481E99ADYazorman@.127.0.0.1...
>|||Marco Napoli wrote:
> The Copy Database Wizard starts and is successfull with the first 4 steps
> but the last 5th step never finishes. I have tried moving all of the
> databases at the same time. Or Just moving one small database and the Wiza
rd
> never finishes with no errors.
How long have you waited for it to finish?
Austin|||Marco Napoli (marco@.avantitecnospam.com) writes:
> I have tried using the CDW using the attache/detach and the SMO method.
> Both gave me the same results, the wizard keeps going.
> I am not opposed to do a backup/restore but I am trying to figure out
> how to do all of the 240 database in one night. The server can only be
> down from 10:00 pm until morning. I have not figured out an automated
> way to restore all db's from backup and recreate all logins for each
> db.
Are you doing this for a final migration or for testing only?
As long as you are testing, there is no need to take the server down
for backup/restore.
Are the user SQL logins, or are they only Windows logins? I made a quick
test, and it seems that for Windows logins the SID is the same (at least
if the servers are in the same domain), in which case there will not be
any mapping problem.
For SQL logins it's more complicated, but make a test with a database or
two, and see where sp_change_users_login takes you.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||I have waited about 4 hours to move one database. Then I tried with another
real small database and it still never finished. Its weird...
Marco
"AustinMN" <tacooper260@.hotmail.com> wrote in message
news:1135706528.891088.247840@.f14g2000cwb.googlegroups.com...
> Marco Napoli wrote:
> How long have you waited for it to finish?
> Austin
>|||In the past when we have moved from one SQL Server 2000 to another box, we
had to do it in the same night after 10:00pm because of the users in the
West Coast. We spoke about giving a notice to our users that we will have
the site down for the wend, so it is an option.
Currently I am trying to do a trial run with just copying one database at a
time but the Copy Database Wizard is not finishing. I wonder if anyone else
has better success. I accept all default options except for trying both ways
detach/attach and leaving db online.
Yes we have tested and the SQL 2000 code is working in SQL Server 2005.
Thanks
Marco
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:ecqvtetCGHA.2840@.TK2MSFTNGP12.phx.gbl...
> Hi Marco
> This sounds like you may be burning your bridges a bit! Do you need to
> move all databases at once? Is your time window applicable at wends?
> Can existing backup jobs be utilised?
> A trial run should give you an idea of timings and will also help you plan
> the migration.
> Have you checked that the code for your stored procedures/views/functions
> are still compatible?
> For logins check out:
> http://support.microsoft.com/kb/246...122120121120120
> John
> "Marco Napoli" <marco@.avantitecnospam.com> wrote in message
> news:uFlqmVnCGHA.900@.TK2MSFTNGP10.phx.gbl...
>