Member Avatar for jaspertan

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 .

  • 2 Contributors
  • 1 Reply
  • 281 Views
  • 18 Hours Discussion Span
  • Latest Post Latest Post by AleMonteiro
Member Avatar for AleMonteiro

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
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.