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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Restore Problem
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sanjay5219
Posting Yak Master

240 Posts

Posted - 10/14/2012 :  02:45:17  Show Profile  Reply with Quote
Hi All,

I am having Sql 2000 in my desktop and yesterday I have done some changes and taken the backup and restore the database in my Laptop (Windows XP) and it was working fine.

Today morning i have again done some changes in desktop and taken the backup and now when i am trying to restore after some time it is giving me and I/O error. and rstoration failed message coming

Please suggest

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2179 Posts

Posted - 10/14/2012 :  12:07:16  Show Profile  Visit jackv's Homepage  Reply with Quote
what is the exact error message?
Did the backup finish without error?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

prett
Posting Yak Master

USA
211 Posts

Posted - 10/15/2012 :  02:53:19  Show Profile  Visit prett's Homepage  Reply with Quote
There are multiple I/O error messages due to restoration process get failed. It may be happen if your database get corrupted. But this is only the one reason behind I/O error. Please mention your full error message So I can recommend you the better solution.

Edited by - prett on 10/15/2012 02:54:01
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2179 Posts

Posted - 10/16/2012 :  01:50:32  Show Profile  Visit jackv's Homepage  Reply with Quote
Do you have an older backup?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000