Hi guys,

is it possible for me to downgrade server .

i tried to restore .bak file from 2008 r2 to 2005 but it has a compatibility error./

can anyone could help me on this matter.

Thanks in advance .

I ain't sure, but I think you can't do it with backup (.bak).

What you can do it's generate scripts from the 2008 to the 2005:

1.Right click on the DB -> Tasks -> Generate Scripts
2.Select all the objects
3.Click Advanced
    3.1.Change Script for Server Version: SQL Server 2005
    3.2.Change Types of data to script: Schema and Data

If you don't have an working version of your DB in a 2008 enviorement, you'll need to create one.

Hope it helps.

commented: Solid working advice +3