Re: Copy Database Wizard

Thanks Andrew. I've seen you post this response before and have read through
all of the links, but none say anything about it just locking up. I can
certainly use the backup and restore or detach and attach methods, but I'd
still like to use DTS to move the logins, jobs, etc. I'm thinking it may be
a permission issue on my target server but I can't pin point it. It looks
like I have the exact same permissions on all of my servers.

"Andrew J. Kelly" wrote:

> Here is an article that list common "Copy DB Wizard" errors. I don't know
> if yours is listed or not.
> http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues
>
> Here are some other associated links that you may find useful:
>
> http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
> http://www.databasejournal.com/features/mssql/article.php/3379901 Moving
> system DB's
> http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
> http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
> to a New Location with Detach/Attach
> http://support.microsoft.com/?id=221465 Using WITH MOVE in a
> Restore
> http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
> Passwords Between SQL Servers
> http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
> Restore
> http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
> users
> http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
> Errors After Restoring Dump
> http://www.support.microsoft.com/?id=240872 How to Resolve Permission
> Issues When a Database Is Moved Between SQL Servers
> http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
> Restoring a .mdf
> http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
> for SQL Server
>
>
> Personally I have never had anything but trouble with the wizard and found
> that scripting the backup & restore or attach was much easier, faster and
> cleaner.
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "Ryan" <Ryan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:C1EFCDC6-B26C-4F53-B2C5-6BCC4972E4C5@xxxxxxxxxxxxxxxx
> >I am in the process of consolidating 17 SQL servers into 3 (yes they
> > extremely under-utilized). I am trying to use the Copy Database Wizard to
> > do
> > this, mostly because there are a couple hundred databases that need to be
> > moved and it would be very tedious to do each one via backup and restore
> > or
> > detach and attach. I am having some issues with moving the logins but I
> > can
> > deal with that. My biggest problem is one of my target servers doesn't
> > seem
> > to want to accept anything from the CDW. When attempting to copy from
> > Server
> > A to Server B, it just locks up with no error message, no status screen,
> > nothing. I can copy from A to C, or even B to C, but B just can't be the
> > target for some reason. Is there a setting or configuration that I'm
> > missing? Any help would be greatly appreciated. Thanks in advance.
> >
> > Ryan
>
>
>
.

Relevant Pages

  • Re: SQL 2000 SP4 on 2003 Server - Single User Mode
    ... I found the section where you list the filename to restore to. ... rename the SQL Server the same as what is listed below Courthouse? ... Once you've created your database (simply right click on the Database ...
    (microsoft.public.sqlserver.setup)
  • Re: Two Disaster Recovery Questions
    ... I support the Professional Association for SQL Server ... > recovery site ... > second restore at the recovery site. ...
    (microsoft.public.sqlserver.server)
  • Re: test environment windows 2003
    ... an authorative restore after the demote and system state restore. ... Remove the physical cable for the new pc and build the member server ... At a command prompt type in NTBACKUP and do a system state backup saving ... Master Operation roles (FSMO and the File Replication service). ...
    (microsoft.public.windows.server.active_directory)
  • Re: Exchange Server Restore From Backup - Help Needed
    ... had to modify the backup so that the Exchange Server files were only ... when I come to do a restore the only option I ... get is to restore to the current machine or to another Exchange Server. ... Because the Travan Tape only holds 20GB uncompressed 40GB compressed, ...
    (microsoft.public.windows.server.sbs)
  • Re: Cant restore master db!!
    ... I tried starting the server as you & Hari instructed; the server started in single user mode. ... the restore has to be issued from the Veritas software interface. ... SQL Server returned the following error message: ...
    (microsoft.public.sqlserver.server)