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 2005 Forums
 Transact-SQL (2005)
 Restore Problem

Author  Topic 

sanjay5219
Posting Yak Master

240 Posts

Posted - 2012-10-14 : 02:45:17
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
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-10-14 : 12:07:16
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

212 Posts

Posted - 2012-10-15 : 02:53:19
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.
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-10-16 : 01:50:32
Do you have an older backup?

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

- Advertisement -