Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Restore Fails

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-09-12 : 10:53:29
Kathy writes "Hello,

I am attemping to restore a 66 GB database and it seems to get up to 50 Percent and then I get the error

---This error is reported in the SQL Analyzer.
40 percent backed up.
50 percent backed up.
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
Backup or restore operation terminating abnormally.

I am running
Windows 2000 Advanced Server SP2
Microsoft SQL 7.0 Service Pack 3


I thougth this was a network issue so I used a dedicated connection from the backup location to where I was planning to restore it to. and it still failed with the same error.

I then thought my backup might have been corrupt so I got a new backup, and I still go the same error.


Any feedback is highly appreaciated

Kathy Reyes

kreyes@livetechnology.com"

royv
Constraint Violating Yak Guru

455 Posts

Posted - 2002-09-12 : 10:56:31
How are you attempting the restore? Via EM or via TSQL code through QA?

*************************
Someone done told you wrong!
Go to Top of Page

chadmat
The Chadinator

1974 Posts

Posted - 2002-09-12 : 13:28:45
Probably your issue:

http://support.microsoft.com/support/kb/articles/q291/2/28.asp

Go to Top of Page
   

- Advertisement -