Optimal restore of database

How can I restore Database_1 on MSSQL2K server with minimal effect on working users of Database_2 ?
When I use EM (restore with create), users are getting "General network error" for 5 minutes.Hopefully you're not pulling the backup from across the network. Remember that, restoring does take some taxing on the server resources. However, this should not drop your users.

Take a look at perfmon/netmon to see what's going on.

Operational but able to restore additional transaction logs

I have databases which have been left in the operational, but able to restore
additional transaction logs mode. I had done this last week thinking I could
easily setup log shipping that day. Tonight's backup will be the first full
backup corresponding with transaction log backups. The full backup will need
to run against this database which currently shows (loading) as its state.
Should this be removed or fixed somehow - at this point, I cannot delete, or
restore, or anything else including go to the properties to reset the state
because the database is not in the databases collection for this server...
so, what do I do now?
Regards,
Jamie
Wow, I figured that one out. I checked the sysdatabases as I had tried to
detach the database that was indicated as loading. Detaching removes it
from the sysdatabases. I only needed to refresh the Enterprise Manager.
Regards,
Jamie
"thejamie" wrote:

> I have databases which have been left in the operational, but able to restore
> additional transaction logs mode. I had done this last week thinking I could
> easily setup log shipping that day. Tonight's backup will be the first full
> backup corresponding with transaction log backups. The full backup will need
> to run against this database which currently shows (loading) as its state.
> Should this be removed or fixed somehow - at this point, I cannot delete, or
> restore, or anything else including go to the properties to reset the state
> because the database is not in the databases collection for this server...
> so, what do I do now?
> --
> Regards,
> Jamie

Operating System Error 2

What backup tool is being reference in the KB article below?
http://support.microsoft.com/kb/937683
I am getting this exact scenario trying to restore a backup and I am trying
to determine which backup tool is being reference.
SQL Writer Service
http://technet.microsoft.com/en-us/library/ms175536.aspx
hth
"billinny" wrote:

> What backup tool is being reference in the KB article below?
> http://support.microsoft.com/kb/937683
> I am getting this exact scenario trying to restore a backup and I am trying
> to determine which backup tool is being reference.