RE: Copy Database Wizard

Thanks Allan. Does the Backup and Restore take all of the logins, jobs, etc
with it?

"Allan Mitchell" wrote:

> Even though you have a few dbs to back up I would still be using BACKUP RESTORE
>
> You can generate the syntax to do this
>
> SELECT 'BACKUP DATABASE ' + name + ' TO DISK = '<location>'
> FROM master.dbo.Sysdatabases
>
> You can then generate a script to do the restores as well.
>
> I dislike the CDW as it has some quirks as you are experiencing
>
> "Ryan" wrote:
>
> > 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

  • Backup and Restore Files
    ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
    (microsoft.public.access.gettingstarted)
  • Re: sql 2008 evaluation edition upgrade
    ... restore logins. ... I suggest you to see BACKUP and RESTORE commands from Books Online. ... You also may want to use Maintanence Plans to backup your databases (not ...
    (microsoft.public.sqlserver.setup)
  • Re: [opensuse] About Backing Up
    ... there is a data failure we can restore. ... the restoration is to get the backup file that we first complete as it ... failure, physical destruction, or it has been half inched. ... Other data should be archived to media. ...
    (SuSE)
  • Re: Exchange in Recovery Mode
    ... On the backup SBS server, did you restore Mailbox Store from backup ... After Mailbox Store was restored, ... Create a Recovery Storage Group. ... Restore the backup to Recovery Storage Group with NTbackup. ...
    (microsoft.public.windows.server.sbs)
  • Re: Computer problem, need help
    ... >>> defining the three levels of backup and recovery. ... >>> has been corrupted, use backup and restore. ... >>hard drives and a reliable backup utility like Ghost. ... doesn't work I use my preferred backup utility, ...
    (soc.retirement)