I need to backup my CRM databases to another SQL server 2000 computer using
the copy wizard but i received this error message " there are 2 active
connections to the database" so the database was not copied to the second
server.

Some of the databases were also referred to as replicated database. how do i
copy them to the second server.

Thanks

Not sure why the message but why don't you simply do a backup and restore?
The copy db process is so much more complicated and very inefficient.

--
Andrew J. Kelly SQL MVP


"bisigreat" <bisigreat (AT) discussions (DOT) microsoft.com> wrote

Thanks Kelly, i tought copy will make the job faster instead of backing up
and then restore on another SQL server. Is there no tool in SQL server 2000
that i can use to transfer the databases while the 2 servers are running.

Thanks.

"Andrew J. Kelly" wrote:

A native sql server backup is an online operation. There is no need to shut
down sql server while doing a SQL backup.

--
Andrew J. Kelly SQL MVP


"bisigreat" <bisigreat (AT) discussions (DOT) microsoft.com> wrote

Thanks Kelly for the answer.

"Andrew J. Kelly" wrote:

Hello Kelly,

I have used the normal backup as you adviced. i transfered those backup
files to a folder on the second SQL 2000 server. I followed the steps below
on the second server. I

1. right click Database folder=>All Tasks=>Restore Database
2. From device and browse to the folder containing the copied backup files

I got this error message "Device Activation error.......Use WITH MOVE to
identify a valid location for the file"

"bisigreat" wrote:

If the database files (.mdf and .ldf) will not be in the same dir names as
they were on the original server you must change the physical paths of each
filename on the second tab of the Restore dialog. Or use Query Analyzer and
TSQL. Here is a sample from BooksOnLine on how to restore a db to a
different physical location:

RESTORE DATABASE MyNwind
FROM MyNwind_1
WITH NORECOVERY,
MOVE 'MyNwind' TO 'c:\Program Files\Microsoft SQL
Server\MSSQL\Data\NewNwind.mdf',
MOVE 'MyNwindLog1' TO 'c:\Program Files\Microsoft SQL
Server\MSSQL\Data\NewNwind.ldf'
RESTORE LOG MyNwind
FROM MyNwindLog1
WITH RECOVERY


--
Andrew J. Kelly SQL MVP


"bisigreat" <bisigreat (AT) discussions (DOT) microsoft.com> wrote

A big thank you to you Kelly. The peoblem was solved when i changed the
physical location of the .mdf and .ldf files on the second server. I
appreciate your contribution. Cheers

Bisi

"Andrew J. Kelly" wrote: