SQL Restore from 2008R2 to 2005

[H_Sharma]

Hello Experts,

I have been trying to restore database from 2008R2 to 2005 and getting below error.

On dbclient I could see the below log

The media family on device 'VNBU0-51452-'is incorrectly formed. SQL Server cannot process this media family.>.

Source Server Details.

SQL Server 2008 R2
Microsoft SQL Server Management Studio      10.50.4042.0
Microsoft Analysis Services Client Tools          10.50.4042.0
Microsoft Data Access Components (MDAC)      6.1.7601.17514
Microsoft MSXML      3.0 4.0 6.0
Microsoft Internet Explorer      8.0.7601.17514
Microsoft .NET Framework      2.0.50727.5485
Operating System      6.1.7601

Destination Server

Sql Server 2005

Microsoft SQL Server Management Studio      9.00.5000.00
Microsoft Analysis Services Client Tools      2005.090.5000.00
Microsoft Data Access Components (MDAC)      6.1.7601.17514 (win7sp1_rtm.101119-1850)
Microsoft MSXML      3.0 4.0 5.0 6.0
Microsoft Internet Explorer      8.0.7601.17514
Microsoft .NET Framework      2.0.50727.5485
Operating System      6.1.7601

Is this restoration supported?

Please help me.

[H_Sharma]

Let me also tell you . I am restoring a single database not the whole db into the 2005 server.

[PatS729 · Accepted solution]

Simple answer "NO". You cannot restore a backup from a higher version of SQL Server on a lower version of SQL Server.
 

[H_Sharma]

Thanks So much Pat

Is there any Veritas T/N?

[PatS729]

Its a limitation of SQL, I doubt if Veritas has any published article for this.

[Marianne]

Not Veritas issue. This is Microsoft issue. So, for documentation, contact Microsoft.

[Michael_G_Ander]

You neeed to install at least SQL 2008 R2 binaries on the destination server, SQL is backward compatible but for good reasons not forward compatible.