Anyone know how to stop a restore? "Database cannot be opened. It is in the middle of a re

Hi,
This is my first post here.
I'm running SQL Server 2000 and have a database that cannot be backed
up properly because it "is in the middle of a restore." This is because
of a restore that was started and then stopped.
Users are still able to add data to the database, so I would prefer to
simply stop the restore if possible, rather than run the restore again,
as the backup I have is two days old.
Any help GREATLY appreciated!
thank you,
Brian Honeycutt
Hi,
thanks for the reply.
How would I refresh the EM?
You may be right in that they are connecting to a different SQL
database.
Still, I would like to backup this DB up if possible. But that entails
completing the restore or stopping it somehow.
Any ideas on that?
thanks a lot,
brian
On Dec 15, 9:12 am, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:[vbcol=seagreen]
> If the database is really in the middle of a restore, then no-one can connect to the database.
> Perhaps you just didn't refresh EM? Or perhaps those users are working against some other database?
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://www.solidqualitylearning.com/
> <brian.honeyc...@.retiregroup.com> wrote in messagenews:1166199871.800873.82680@.j72g2000cwa.go oglegroups.com...
>
>
>
|||<brian.honeycutt@.retiregroup.com> wrote in message
news:1166199871.800873.82680@.j72g2000cwa.googlegro ups.com...
> Hi,
> This is my first post here.
> I'm running SQL Server 2000 and have a database that cannot be backed
> up properly because it "is in the middle of a restore." This is because
> of a restore that was started and then stopped.
> Users are still able to add data to the database, so I would prefer to
> simply stop the restore if possible, rather than run the restore again,
> as the backup I have is two days old.
Also, just to make sure...
do a restore database foo WITH RECOVERY
(I think you get a different error message if the db hasn't been fully
recovered, but it may be this simple.)

> Any help GREATLY appreciated!
> thank you,
> Brian Honeycutt
>