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 .
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.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.