Wrox Programmer Forums
|
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 6th, 2006, 10:56 AM
Friend of Wrox
  
Join Date: Oct 2006
Posts: 112
Thanks: 12
Thanked 0 Times in 0 Posts
Default restore DB error
Hi all,

I want to restore my live DB to my test DB so I can do some testing... But when I do so, I get more then half way to the restore and I get and error "Nonrecoverable I/O error"...

Can someone explain why...
I do a full backup and it works fine...
And thats what I want to restore from...

Thanking you in advance...
Rino
 
Old October 6th, 2006, 11:07 AM
SQLScott's Avatar
Wrox Author
  
Join Date: Dec 2004
Posts: 338
Thanks: 0
Thanked 2 Times in 2 Posts
Default
How are you backing up? Are you backing up to a device or a file? Are the two dbs on separate machines? Are you copying the backup from one location to another or are you simply restoring from the original backup location?

Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html
 
Old October 6th, 2006, 02:12 PM
Friend of Wrox
  
Join Date: Oct 2006
Posts: 112
Thanks: 12
Thanked 0 Times in 0 Posts
Default
I'm backing up to a file...
The two DB's are on the same machine...
Just from an original location...
 
Old October 6th, 2006, 02:20 PM
SQLScott's Avatar
Wrox Author
  
Join Date: Dec 2004
Posts: 338
Thanks: 0
Thanked 2 Times in 2 Posts
Default
I would try the following:
1) delete the old backup file
2) backup to a file in another location on the hard drive
3) restore

it could be that for some reason the original file has become corrupt...

Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html
 
Old October 6th, 2006, 03:19 PM
Friend of Wrox
  
Join Date: Oct 2006
Posts: 112
Thanks: 12
Thanked 0 Times in 0 Posts
Default
I did that and I got this error...
"Consider using the WITH MOVE option to identify valid location"

I just re-did it and now it worked...

I don't know...
 
Old October 6th, 2006, 03:29 PM
SQLScott's Avatar
Wrox Author
  
Join Date: Dec 2004
Posts: 338
Thanks: 0
Thanked 2 Times in 2 Posts
Default
Well, glad you got it working...

Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html
 
Old October 6th, 2006, 04:18 PM
Friend of Wrox
  
Join Date: Oct 2006
Posts: 112
Thanks: 12
Thanked 0 Times in 0 Posts
Default
Thanks





Similar Threads
Thread Thread Starter Forum Replies Last Post
DB Restore somnath.kartic SQL Server 2005 1 July 12th, 2007 07:36 AM
Restore from DB error... RinoDM SQL Language 0 October 6th, 2006 10:18 AM
How to restore thePhile db? Margie BOOK: ASP.NET Website Programming Problem-Design-Solution 1 August 2nd, 2006 10:07 PM
Backup restore error Prabhakar_dt Classic ASP Basics 1 July 21st, 2005 07:20 PM
DB Restore User Logins onto different server plandis98 SQL Server 2000 1 November 25th, 2004 10:36 PM




Contact Us - Wrox - Privacy Statement - Top

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.