Back up restore problem

Question

Back up restore problem

manoharanpraveen

Say Hey Kid

Points: 711
More actions
December 15, 2010 at 4:18 pm

#232102

We are trying to restore a Database from one server to another. Both the servers are SQL server 2005. So no compatability with version. But the source is windows 2003 and the destination is window 2008.
We are able to restore the back up on the source .So no problem with the back up files.
When we try to restore in destination server it gives us the following error.
BackupIoRequest::WaitForIoCompletion: read failure on backup device 'blah blah'. Operating system error 1.
any one have any idea to overcome this.??

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Sounds like Operating system permissions. Does the SQL Service account on the destination have permissions to the source directory as well as the directory for the destination data and log files?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

manoharanpraveen Say Hey Kid Points: 711 More actions · Answer 2

Thanks for looking into the problem.

the answer for the question is:

Yes. It has admin access.

Thanks.

Steve Jones - SSC Editor SSC Guru Points: 736568 More actions · Answer 3

SQL Server doesn't do a lot of retrying across the network. If you have any hiccup, it can fail. Unlike a file transfer, the backup/restore process typically requires a fairly smooth stream of packets.

Can you copy the file locally to the second server and try to restore?

manoharanpraveen Say Hey Kid Points: 711 More actions · Answer 4

I m receiving below error when I am trying to copy the backup file from H:\Full to G:\.

Error: Invalid MS Dos function.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

manoharanpraveen (12/16/2010)
I m receiving below error when I am trying to copy the backup file from H:\Full to G:\.
Error: Invalid MS Dos function.

What was the command you used?

Also, is G or H a local attached disk or san disk?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

manoharanpraveen Say Hey Kid Points: 711 More actions · Answer 6

Yes G and H are local drives.

We have reported the problem to the windows team. They are working on it.

I will keep updated when i get any updates from them.

Thanks