SQL Server Forums
Profile | Register | 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
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sanjay5219
Posting Yak Master

229 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
2067 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
203 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
2067 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  
 New 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.05 seconds. Powered By: Snitz Forums 2000