Find solution
How to Restrict Database for One User in SQL Server 2008 R2?

Why do i can't restore database in sql server 2005 from the database in sql server 2008?

  • I back up the database in sql server 2008 to the file has extension ".bak". After i send it for my friends in group. He said "i can't restore the file to database in sql server 2005"? Can you help me? Thanks!

  • Answer:

    Because they're not backwards compatable. You'd see the exact same problems if you tried to open a MS Word Document made with Word 2010 in Word 95. The later versions contain features the earlier versions just have no clue how to handle. (They still have the same extension) See if you have the option to save the database in an older format, or tell him he needs to upgrade to at least 2008

Ko aj ca at Yahoo! Answers Visit the source

Was this solution helpful to you?

Other answers

Go to properties on the database, Options section, set the compatibility level to Server 2005. Back up the database now and try restoring it again. Outside of this, you cannot restore or attach an 08 DB to an 05 server. Or restore it to an 08 server, change this setting and re-back it up to restore it on the 05 server.

If your DB does not use specific features of SS2008, you could generate script of entire DB (dump) and run this script on SS2005.

Maybe it´s compatibility issues

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.