Backup/Restore Server OS to XP Pro

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

General SQL Server Forums

New to SQL Server Administration

Backup/Restore Server OS to XP Pro

Author

Topic

samuelshulman
Starting Member

3 Posts

Posted - 2011-10-26 : 12:48:33

Hi

I have done a simple successful backup of the database which resided on a server OS and I am unable to restore it to the same version database residing on Win XP Pro.

Ant explanations or fix?

Thank you
Samuel

Sachin.Nand

2937 Posts

Posted - 2011-10-26 : 15:05:30

Whats the error that you get ?

PBUH

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-10-26 : 15:36:24

Nothing to do with the OS. I do that kind of thing regularly.

--
Gail Shaw
SQL Server MVP

samuelshulman
Starting Member

3 Posts

Posted - 2011-10-26 : 15:48:38

The message I get is an exception occurred while executing a transaction-SQL statement.. (Microsoft.SQLServer.ConnectionInfo)
Additinal information:
Read on C:\File name failes: 38(failed to retrieve text for this error. Reason: 1815) Microsoft SQL Server, Error 3203))

Thank you for your help
Samuel

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-10-26 : 16:05:57

Error 38 is 'reached the end of the file'. Implies that the backup file has been truncated (cut off) during transfer Get a new backup, that one's damaged.

--
Gail Shaw
SQL Server MVP

samuelshulman
Starting Member

3 Posts

Posted - 2011-10-26 : 16:43:53

Thank you Gail.

Apparently the file was not copied properly in the first instance.

Best regards,
Samuel

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources