i need for this

Question

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 How to convert sql server 2012 backup to sql server 2008 R2? can any one plz tell me this answer...................... /* Style Definitions */ table.MsoNormalTable {mso-style-name:Table Normal; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:Calibrisans-serif; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Times New Roman; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:Times New Roman; mso-bidi-theme-font:minor-bidi;}

Sanjeeb Lenka · Answer

hi it's not possible to restore a backup file from a higher version to a lower version of SQL Server.but another way is there you can create a script of the database and execute it in lower version of sql server. http://www.webcodeexpert.com/2013/05/how-to-create-sql-server-database.html#.Uh7gPCJlfcw http://www.dotnetfunda.com/articles/article1240-generate-sql-server-scripts-using-wizard-.aspx

Iftikar Hussain · Answer

I don't have any idea for reverse version restore

Rosi Sreenivasa Reddy · Answer

hai Hussain can you say any way to get that plz send urgent..............................

Iftikar Hussain · Answer

Hi I think it is not possible. You can only move forward. This means you can restore the database from 2005 or 2008 to 2012 version but can not do it in reverse order. Regards Iftikar