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 HoneycuttIf 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 MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<brian.honeycutt@.retiregroup.com> wrote in message
news:1166199871.800873.82680@.j72g2000cwa.googlegroups.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.
> 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:
> 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.googlegroups.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.
> > Any help GREATLY appreciated!
> > thank you,
> > Brian Honeycutt- Hide quoted text -- Show quoted text -|||> How would I refresh the EM?
Right-click the "Databases" folder and click "Refresh".
It should be find just to execute the RESTORE command again. If the GUI won't let you, try from a
query window.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<brian.honeycutt@.retiregroup.com> wrote in message
news:1166205293.356794.239060@.n67g2000cwd.googlegroups.com...
> 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:
>> 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.googlegroups.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.
>> > Any help GREATLY appreciated!
>> > thank you,
>> > Brian Honeycutt- Hide quoted text -- Show quoted text -
>|||<brian.honeycutt@.retiregroup.com> wrote in message
news:1166199871.800873.82680@.j72g2000cwa.googlegroups.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
>sql