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

any way to rollback dbase

Hi just wondering if there is anyway to roll back a database? For example
the last time the database was backed up say 3 months ago and a restore was
done yesterday. Just wondering if there is anyway to undo the restore?
Thanks.
Paul G
Software engineer.
No, a database restore can't be undone because all data in the target are
replaced during the restore.
Hope this helps.
Dan Guzman
SQL Server MVP
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:9A8E7FFE-2DFA-4FAC-AE0F-2BB8BF026E1C@.microsoft.com...
> Hi just wondering if there is anyway to roll back a database? For example
> the last time the database was backed up say 3 months ago and a restore
> was
> done yesterday. Just wondering if there is anyway to undo the restore?
> Thanks.
> --
> Paul G
> Software engineer.
|||"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:9A8E7FFE-2DFA-4FAC-AE0F-2BB8BF026E1C@.microsoft.com...
> Hi just wondering if there is anyway to roll back a database? For example
> the last time the database was backed up say 3 months ago and a restore
> was
> done yesterday. Just wondering if there is anyway to undo the restore?
> Thanks.
> --
> Paul G
> Software engineer.
Sure -- this can be easily done.
Assuming you have a backup you took immediately
prior to the restore.
What's that? You don't have one? Well, why not?
Chalk this one up as a lesson learned.
Really, there's no way without another backup
that was taken just prior to the restore.
|||Hi,
No you cant do a recovery back if you restore a full database backup.
Here after please do a backup and keep yourself safe before restoring.
Thanks
Hari
SQL Server MVP
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:9A8E7FFE-2DFA-4FAC-AE0F-2BB8BF026E1C@.microsoft.com...
> Hi just wondering if there is anyway to roll back a database? For example
> the last time the database was backed up say 3 months ago and a restore
> was
> done yesterday. Just wondering if there is anyway to undo the restore?
> Thanks.
> --
> Paul G
> Software engineer.
sql

any way to rollback dbase

Hi just wondering if there is anyway to roll back a database? For example
the last time the database was backed up say 3 months ago and a restore was
done yesterday. Just wondering if there is anyway to undo the restore?
Thanks.
--
Paul G
Software engineer.No, a database restore can't be undone because all data in the target are
replaced during the restore.
Hope this helps.
Dan Guzman
SQL Server MVP
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:9A8E7FFE-2DFA-4FAC-AE0F-2BB8BF026E1C@.microsoft.com...
> Hi just wondering if there is anyway to roll back a database? For example
> the last time the database was backed up say 3 months ago and a restore
> was
> done yesterday. Just wondering if there is anyway to undo the restore?
> Thanks.
> --
> Paul G
> Software engineer.|||"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:9A8E7FFE-2DFA-4FAC-AE0F-2BB8BF026E1C@.microsoft.com...
> Hi just wondering if there is anyway to roll back a database? For example
> the last time the database was backed up say 3 months ago and a restore
> was
> done yesterday. Just wondering if there is anyway to undo the restore?
> Thanks.
> --
> Paul G
> Software engineer.
Sure -- this can be easily done.
Assuming you have a backup you took immediately
prior to the restore.
What's that? You don't have one? Well, why not?
Chalk this one up as a lesson learned.
Really, there's no way without another backup
that was taken just prior to the restore.|||Hi,
No you cant do a recovery back if you restore a full database backup.
Here after please do a backup and keep yourself safe before restoring.
Thanks
Hari
SQL Server MVP
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:9A8E7FFE-2DFA-4FAC-AE0F-2BB8BF026E1C@.microsoft.com...
> Hi just wondering if there is anyway to roll back a database? For example
> the last time the database was backed up say 3 months ago and a restore
> was
> done yesterday. Just wondering if there is anyway to undo the restore?
> Thanks.
> --
> Paul G
> Software engineer.

any way to rollback dbase

Hi just wondering if there is anyway to roll back a database? For example
the last time the database was backed up say 3 months ago and a restore was
done yesterday. Just wondering if there is anyway to undo the restore?
Thanks.
--
Paul G
Software engineer.No, a database restore can't be undone because all data in the target are
replaced during the restore.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:9A8E7FFE-2DFA-4FAC-AE0F-2BB8BF026E1C@.microsoft.com...
> Hi just wondering if there is anyway to roll back a database? For example
> the last time the database was backed up say 3 months ago and a restore
> was
> done yesterday. Just wondering if there is anyway to undo the restore?
> Thanks.
> --
> Paul G
> Software engineer.|||"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:9A8E7FFE-2DFA-4FAC-AE0F-2BB8BF026E1C@.microsoft.com...
> Hi just wondering if there is anyway to roll back a database? For example
> the last time the database was backed up say 3 months ago and a restore
> was
> done yesterday. Just wondering if there is anyway to undo the restore?
> Thanks.
> --
> Paul G
> Software engineer.
Sure -- this can be easily done.
Assuming you have a backup you took immediately
prior to the restore.
What's that? You don't have one? Well, why not?
Chalk this one up as a lesson learned.
Really, there's no way without another backup
that was taken just prior to the restore.|||Hi,
No you cant do a recovery back if you restore a full database backup.
Here after please do a backup and keep yourself safe before restoring.
Thanks
Hari
SQL Server MVP
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:9A8E7FFE-2DFA-4FAC-AE0F-2BB8BF026E1C@.microsoft.com...
> Hi just wondering if there is anyway to roll back a database? For example
> the last time the database was backed up say 3 months ago and a restore
> was
> done yesterday. Just wondering if there is anyway to undo the restore?
> Thanks.
> --
> Paul G
> Software engineer.