Restore Database

I'm trying to create a DTS to back up the database from
one server and restore it to another server but it keeps
telling me that the database cannot be restored because it
is in use. The connection for the restore points to the
server I want to restore to and I even created a new
database to restore to and check under current activity
and it not in use. What am I doing wrong?
Thanks.First, DTS is not the way to back up and restore a
database. You should be using BACKUP and RESTORE. And if
you have a connection into the DB for some reason, that
will cause conflict. The DB can have no connection in.
So switching to a traditional BACKUP/RESTORE will
hopefully help your problem.
>--Original Message--
>I'm trying to create a DTS to back up the database from
>one server and restore it to another server but it keeps
>telling me that the database cannot be restored because
it
>is in use. The connection for the restore points to the
>server I want to restore to and I even created a new
>database to restore to and check under current activity
>and it not in use. What am I doing wrong?
>Thanks.
>.
>|||You can use dts to accomplish your task. You can use
robocopy and use dts to run it.
>--Original Message--
>I'm trying to make this an automated nightly thing. The
>DTS was doing the backup and restore. I think I now
>understand about the connection being the problem. I
need
>to back up a database on another server so I think I
need
>to use a DTS so I can get to it? I'll try changing to
>just have the back up in the DTS and then schedule it
and
>then modify the schedule to restore the database to the
>local server after the backup completes.
>Thanks.
>>--Original Message--
>>First, DTS is not the way to back up and restore a
>>database. You should be using BACKUP and RESTORE. And
if
>>you have a connection into the DB for some reason, that
>>will cause conflict. The DB can have no connection in.
>>So switching to a traditional BACKUP/RESTORE will
>>hopefully help your problem.
>>
>>--Original Message--
>>I'm trying to create a DTS to back up the database
from
>>one server and restore it to another server but it
keeps
>>telling me that the database cannot be restored
because
>>it
>>is in use. The connection for the restore points to
the
>>server I want to restore to and I even created a new
>>database to restore to and check under current
activity
>>and it not in use. What am I doing wrong?
>>Thanks.
>>.
>>.
>.
>