Copy Database ? Does it ever work?

Is there some secret to getting Copy Database through SQL Server Management
Studio to work? It seems like no matter what I do it always fails.
All I'm trying to do is copy a database from one machine to another. I don't
want to do the detach/attach method because it's a live server with users on
it.
TIA - J.On Feb 12, 9:27 am, "UJ" <f...@.nowhere.com> wrote:
> Is there some secret to getting Copy Database through SQL Server Managemen
t
> Studio to work? It seems like no matter what I do it always fails.
> All I'm trying to do is copy a database from one machine to another. I don
't
> want to do the detach/attach method because it's a live server with users
on
> it.
> TIA - J.
Do a backup/restore. Can't tell you if the wizard ever works or not,
I've never used it.|||I'd go with the backup and restore option.
With regards to your question - I know DB Copy has been a bit flaky in the
past, however, you'll find that it may say its failed when it hasn't and, if
you look closer at the logs, you'll probably find it's because it says it
doesn't copy the users over.
This doesn't mean it's failed, you just need to recreate the users, but
without more info on your failures, i can't say.
Backup and Restore will get you what you need either way.
Immy
"UJ" <fred@.nowhere.com> wrote in message
news:uJZsXprTHHA.4668@.TK2MSFTNGP04.phx.gbl...
> Is there some secret to getting Copy Database through SQL Server
> Management Studio to work? It seems like no matter what I do it always
> fails.
> All I'm trying to do is copy a database from one machine to another. I
> don't want to do the detach/attach method because it's a live server with
> users on it.
> TIA - J.
>