error 3271

Hi everybody,
I'm trying to restore a database (approx. 30 / 50 or 100 GByte) from one
server on a second server.
When nearly reaching the end of the process, the restore stops and I get the
following message:
Server: Msg 3271, Level 16, State 1, Line 1
Nonrecoverable I/O error occurred on file '?'.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
I'm quite sure that the file is ok, because it is restored from tape to
diusk before I start the restore process. I mentioned three different
filesizes because it happens on all of them.
There is also enough space on disk (appro. 360 GB). The disk itself is a
RAID5.
Any ideas ? (tempdb problems / caching?)
thanks in advance
BodoPerhaps the database you did backup on was corrupt? Can you check that with DBCC CHECKDB?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"msnews.microsoft.com" <bodo.meyer@.web.de> wrote in message
news:uyFxmeprDHA.1760@.TK2MSFTNGP10.phx.gbl...
> Hi everybody,
> I'm trying to restore a database (approx. 30 / 50 or 100 GByte) from one
> server on a second server.
> When nearly reaching the end of the process, the restore stops and I get the
> following message:
> Server: Msg 3271, Level 16, State 1, Line 1
> Nonrecoverable I/O error occurred on file '?'.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> I'm quite sure that the file is ok, because it is restored from tape to
> diusk before I start the restore process. I mentioned three different
> filesizes because it happens on all of them.
> There is also enough space on disk (appro. 360 GB). The disk itself is a
> RAID5.
> Any ideas ? (tempdb problems / caching?)
> thanks in advance
> Bodo
>|||I have recently restored a db on our backup box. This might seem
elementary but after I received the same I/O level errors. I used a
cleaning tape in the drive and tried the restore again and was
successful. The optics may be dirty causing data to become corrupt. I
am using a Quantum DLT 4000 drive and the use tape light did come on
when I started the tape restore.
msnews.microsoft.com wrote:
> Hi everybody,
> I'm trying to restore a database (approx. 30 / 50 or 100 GByte) from one
> server on a second server.
> When nearly reaching the end of the process, the restore stops and I get the
> following message:
> Server: Msg 3271, Level 16, State 1, Line 1
> Nonrecoverable I/O error occurred on file '?'.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> I'm quite sure that the file is ok, because it is restored from tape to
> diusk before I start the restore process. I mentioned three different
> filesizes because it happens on all of them.
> There is also enough space on disk (appro. 360 GB). The disk itself is a
> RAID5.
> Any ideas ? (tempdb problems / caching?)
> thanks in advance
> Bodo
>|||Thanks for Your ideas. I think the backup tape is ok, because other restores
work fine. Anyway, I'll try the cleaning. The database corruption must be
verified by another company, that sent me the db. Any idea about different
server language settings? The origin server is a english sqL2K, the target
is german.
Greetings
Bodo
"msnews.microsoft.com" <bodo.meyer@.web.de> schrieb im Newsbeitrag
news:uyFxmeprDHA.1760@.TK2MSFTNGP10.phx.gbl...
> Hi everybody,
> I'm trying to restore a database (approx. 30 / 50 or 100 GByte) from one
> server on a second server.
> When nearly reaching the end of the process, the restore stops and I get
the
> following message:
> Server: Msg 3271, Level 16, State 1, Line 1
> Nonrecoverable I/O error occurred on file '?'.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> I'm quite sure that the file is ok, because it is restored from tape to
> diusk before I start the restore process. I mentioned three different
> filesizes because it happens on all of them.
> There is also enough space on disk (appro. 360 GB). The disk itself is a
> RAID5.
> Any ideas ? (tempdb problems / caching?)
> thanks in advance
> Bodo
>|||Language setting doesn't cause this type of errors (I'm afraid - in your situation :-) ).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Bodo R. Meyer" <bodo.meyer@.web.de> wrote in message news:%23L9QphqrDHA.2448@.TK2MSFTNGP12.phx.gbl...
> Thanks for Your ideas. I think the backup tape is ok, because other restores
> work fine. Anyway, I'll try the cleaning. The database corruption must be
> verified by another company, that sent me the db. Any idea about different
> server language settings? The origin server is a english sqL2K, the target
> is german.
> Greetings
> Bodo
> "msnews.microsoft.com" <bodo.meyer@.web.de> schrieb im Newsbeitrag
> news:uyFxmeprDHA.1760@.TK2MSFTNGP10.phx.gbl...
> > Hi everybody,
> >
> > I'm trying to restore a database (approx. 30 / 50 or 100 GByte) from one
> > server on a second server.
> > When nearly reaching the end of the process, the restore stops and I get
> the
> > following message:
> >
> > Server: Msg 3271, Level 16, State 1, Line 1
> > Nonrecoverable I/O error occurred on file '?'.
> > Server: Msg 3013, Level 16, State 1, Line 1
> > RESTORE DATABASE is terminating abnormally.
> >
> > I'm quite sure that the file is ok, because it is restored from tape to
> > diusk before I start the restore process. I mentioned three different
> > filesizes because it happens on all of them.
> >
> > There is also enough space on disk (appro. 360 GB). The disk itself is a
> > RAID5.
> >
> > Any ideas ? (tempdb problems / caching?)
> > thanks in advance
> > Bodo
> >
> >
>