Backup failed in "Loading" status. How to restart or recover?

I asked this question before but never received a decent answer. When a restore fails, what are the steps to re-start the restore? This should be a very common issue and for the life of me I have been unable to find it in BOL or the MS site! Please let me in on the secret!!

Thanks

You should be able to just re-issue the RESTORE command to complete the restore.

If you want to try to recovery the database, you can issue RESTORE <dbname> WITH RECOVERY, but if you failed in the middle of a restore it will not let you bring up a knonwn inconsistent database.

|||

Hi!

I tried to issue the "Restore With Recovery" but that failed as well. Dropping the database seems to be the only way to reliably correct this situation. I don't have a big objection to this, but shouldn't this be in BOL and prominently covered in the Backup and Recovery doc? It would save us all a lot of time!

Thanks,

Michael

|||If the statement WITH RECOVERY does not work, I would not rely on the recovered backup anymore and start from scratch as you did.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

backup error - error 112

Hi,

When trying to do a full backup, I get write on
c\xxxxxxx\shipmatedb_20050715xxx - failed status 112.

It allow however to do the backup is I select "overwrite existing media"

The only thing that has changed today was that I shrunk the log file....

regards

g"Myth of Sisyphus)." <teller_117@.hotmail.com> wrote in message
news:jiWBe.11504$6e3.772236@.news20.bellglobal.com. ..
> Hi,
> When trying to do a full backup, I get write on
> c\xxxxxxx\shipmatedb_20050715xxx - failed status 112.
> It allow however to do the backup is I select "overwrite existing media"
>
> The only thing that has changed today was that I shrunk the log file....
>
> regards
>
> g

Error 112 seems to be a space issue - run "NET HELPMSG 112" in a Windows
command prompt to see that. If this doesn't help, I suggest you give some
more details about your MSSQL version, your backup strategy, where you're
backing up to, how much free space you have etc.

Simon|||Simon,

Thank you for the explanation, it turns out my disk space was near
zero...Cleared some large files and all is well.

regards

g
"Simon Hayes" <sql@.hayes.ch> wrote in message
news:42d86323_1@.news.bluewin.ch...
> "Myth of Sisyphus)." <teller_117@.hotmail.com> wrote in message
> news:jiWBe.11504$6e3.772236@.news20.bellglobal.com. ..
> > Hi,
> > When trying to do a full backup, I get write on
> > c\xxxxxxx\shipmatedb_20050715xxx - failed status 112.
> > It allow however to do the backup is I select "overwrite existing media"
> > The only thing that has changed today was that I shrunk the log
file....
> > regards
> > g
> Error 112 seems to be a space issue - run "NET HELPMSG 112" in a Windows
> command prompt to see that. If this doesn't help, I suggest you give some
> more details about your MSSQL version, your backup strategy, where you're
> backing up to, how much free space you have etc.
> Simon

Backup error

I have this error:
SQL Server Scheduled Task: 43, 'BackupIBMDat - tempdb' --
Status: Failed
-- Task Invoked on: 1/21/04 1:30:00 AM -- Message: Can't
open dump device '\\.\TAPE0', device error or device off
line. Please consult the SQL Server error log for more
details. (Message 3201)
please help meso does SQL Server error log have anything regarding this?
see if you can run a backup to that \\TAPE0 device. Is the spelling right
for the device name?
"Whill" <anonymous@.discussions.microsoft.com> wrote in message
news:1c8d01c3e050$a5d94130$a001280a@.phx.gbl...
> I have this error:
> SQL Server Scheduled Task: 43, 'BackupIBMDat - tempdb' --
> Status: Failed
> -- Task Invoked on: 1/21/04 1:30:00 AM -- Message: Can't
> open dump device '\\.\TAPE0', device error or device off
> line. Please consult the SQL Server error log for more
> details. (Message 3201)
> please help me

Backup error

I have this error:
SQL Server Scheduled Task: 43, 'BackupIBMDat - tempdb' --
Status: Failed
-- Task Invoked on: 1/21/04 1:30:00 AM -- Message: Can't
open dump device '\\.\TAPE0', device error or device off
line. Please consult the SQL Server error log for more
details. (Message 3201)
please help meso does SQL Server error log have anything regarding this?
see if you can run a backup to that \\TAPE0 device. Is the spelling right
for the device name?
"Whill" <anonymous@.discussions.microsoft.com> wrote in message
news:1c8d01c3e050$a5d94130$a001280a@.phx.gbl...

quote:

---

> I have this error:
> SQL Server Scheduled Task: 43, 'BackupIBMDat - tempdb' --
> Status: Failed
> -- Task Invoked on: 1/21/04 1:30:00 AM -- Message: Can't
> open dump device '\\.\TAPE0', device error or device off
> line. Please consult the SQL Server error log for more
> details. (Message 3201)
> please help me

---

Backup Device setup

I am a novice and have setup a backup device for the
database and one for logs. When I attempt a backup I
recevie a device error. Status = 112. The error log
gives me no definitive reason for the error. CAn anyone
help?Run below from a DOS prompt to get explanation for OS error 112:
NET HELPMSG 112
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
<cneeley@.co.pierce.wi.us> wrote in message
news:09e301c3bf57$e2c38430$3101280a@.phx.gbl...
> I am a novice and have setup a backup device for the
> database and one for logs. When I attempt a backup I
> recevie a device error. Status = 112. The error log
> gives me no definitive reason for the error. CAn anyone
> help?