locked
Attach SQL Server 2008 DB in 2005 compatibility mode to SQL Server 2005? RRS feed

  • Question

  • Hello since SQL Server 2005 can't restore SQL Server 2008 .bak files even if compatiblity mode is set to 2005...is it possible to attach same SQL 2008 .mdf & .ldf files which are in 2005 mode onto a SQL Server 2005?

    Thanks in advance.

    Wednesday, September 24, 2014 12:27 AM

Answers

  • Nope. not possible

    if mdf and ldf are created using SQL 2008 instance then you wont be able to attach them onto a sql 2005 instance


    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    Wednesday, September 24, 2014 1:24 AM
  • Its not possbile to restore or attach any higher version of sql to lower versions..

    May be you can script out and you can create the databases manually in lower versions but there is no direct method for higher to lower version of sql restore or attach detach...


    Raju Rasagounder Sr MSSQL DBA

    Wednesday, September 24, 2014 2:10 AM

All replies

  • Nope. not possible

    if mdf and ldf are created using SQL 2008 instance then you wont be able to attach them onto a sql 2005 instance


    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    Wednesday, September 24, 2014 1:24 AM
  • Its not possbile to restore or attach any higher version of sql to lower versions..

    May be you can script out and you can create the databases manually in lower versions but there is no direct method for higher to lower version of sql restore or attach detach...


    Raju Rasagounder Sr MSSQL DBA

    Wednesday, September 24, 2014 2:10 AM