.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Latest Info on 2008/2008 R2 compatibility

Posted By:      Posted Date: October 20, 2010    Points: 0   Category :Sql Server


We are starting to have 1-2 customers send us SQL 2008 R2 databases that we need to be able to import into our SQL 2008 Server and make changes and then send back to them. At the time it would be stretching it for us to provision a 2008 R2 instance so I am looking at what our options are.

After reading the article below I was under the impression that in 2008 R2 you could export or backup a DB and make it compatible with SQL 2008 but after reading some other posts I am questioning this ability. I understand that this feature will be going away but am wondering about what is possible today.


Any feedback on what our options are would be great.



Lossless Audio Addict

View Complete Post

More Related Resource Links

Compatibility problem: an "sql server 2008 R2" db backup cannot be restored to an "sql server 2008"

To verify if the "2008 R2" version can be restored back to a "2008" dbserver I make an experiment:  construct a database on R2 version ( version : 10.50.xxx )  and backup it; then I try to restore the db backup to a "sql server 2008" db-server ( version : 10.0.xxx ) but get failed. Error message is as shown: The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.2531. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.   Originally I want to upgrade a "2008" server to "2008 r2" , but this problem withdraws me: if I do so , I am afraid all the existing clientuser's dbs cannot be backed up to themselves if they don't have "2008 r2" locally:   if a database is backed up under "2008 r2" environment whereas client user only has "2008" db server, does it mean he cannot restore it anymore?   So I wonder if there is an approach that helps me to create a "backward-compatible" database; when creating database on wizard there is an option to choose "compatibility level" but I don't think it meets my requirement..    Anyone can help me on this ??    

MSSQL Server 2008 Workgroups install to Win 7 - Compatibility issues

I attempted to install MSSQL Server 2008 Workgroups from the DVD to a Win 7 workstation.  Error "This Program has known compatibility issues.  The directions are to download the MSSQL Server Service Pack.  I downloaded SP 1 and SP 2.  Neither SP will install.  The DVD install also has a run option displayed along with the Compatibility message.  I select "Run" and it appeared to install, with Start\Programs\Microsoft SQL Server 2008\Configuration Tools\ SQL Server Installation Center 64bit.  However, running the 64bit installation process results in no change.  My question is how to install the MSSQL Server 2008 Workgroups on the Win 7 machine.  I would appreciate your thoughts.

MSSQL Server 2008 Workgroups install to Win 7 - Compatibility issues

The DVD install for MSSQL Server 2008 Workgroups to Win 7 fails due to known compatibility issues.  I asked for help in the Getting Started with SQL Server Forum and followed a recommendation to slipstream installation with SP1. I followed the procedures at http://blogs.msdn.com/b/joaol/archive/2009/03/20/how-to-install-sql-server-2008-with-sp1-built-in-slipstream-installation.aspx I then ran Setup.exe from the C:\SQLServer2008 folder.  It failed with the following .Net Framework error.  (I previously installed .Net Framework Version 4 which is required by the application needing SQL Server.)  Thanks for help. Microsoft.NET Framework Unhandled exception has occurred in your application.  If you click Continue, the application will ignore this error and attempt to continue.  If you click Quit, the application will close immediately. An error occurred creating the configuration section handler for userSettings/Microsoft.SqlServer.Configuration.LandingPage.Properties.Settings: Could not load file or assembly 'System. Version= PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified. (C:\users\PC User\AppData\Local\Microsoft_Corporation\LandingPage.exe_StrongName_ryspccglaxmt4nhllj5z3thcltsvyyx\\user.config line 5). Details... See the end of this message for details o

what is the latest version for SQL Server 2008 R2

We are using Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)   Apr  2 2010 15:48:46   Copyright (c) Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 5.2 <X64> (Build 3790: Service Pack 2).    LISA86

Report Builder 3.0 Compatibility with SSRS and Sql Server 2008 (not R2)

I've built reports in Report Builder 3.0 (which I love!). I tried to deploy the reports to an instance of SSRS installed with SQL Server 2008 (not R2). I can't deploy the reports - it appears SSRS is not forward compatible with Report Builder 3.0 reports. Would SQL Server 2008 SP1 help? Is there anything I can do to use Report Builder 3.0 with SSRS 2008?

Unfortunately, I cannot install SQL Server 2008 R2 in the production environment (yet).

SQL Server 2008 r2 developer RTM edition not installing on windows 7 64 bit machine with latest serv


This machine had sql server 2008 installed.  I removed it since the upgrade would not work.   The machine currently doesn't have any sql installs.    The error fails during the Setup Support Files step.    Any help on this would be greatly appreciated.  I've included last part of file since you can only include 60k chars here.

2010-09-24 10:14:14 Slp: C:\sql2008r2\x64\FixSqlRegistryKey_x64.exe exit code: 0
2010-09-24 10:14:14 Slp: Launching external tool: C:\sql2008r2\x64\FixSqlRegistryKey_x86.exe
2010-09-24 10:14:14 Slp: ------------------------------------------------------------
2010-09-24 10:14:14 Slp: HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer - OK.
2010-09-24 10:14:14 Slp: HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Client - OK.
2010-09-24 10:14:14 Slp: HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Client\SNI9.0 - OK.
2010-09-24 10:14:14 Slp: HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Client\SNI9.0\GeneralFlags - OK.
2010-09-24 10:14:14 Slp: HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Client\SNI9.0\GeneralFlags\Flag1 - OK.
2010-09-24 10:14:14 Slp: HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Client\SNI9.0\GeneralFlags\Flag2 - OK.
2010-09-24 10:14:14 Slp: HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Client\SNI9.0\LastConnect -

SQL Compatibility mode upgrade from SQL2000 to SQL 2008


Hi, i have a Dynamics AX db that the client asked me to upgrade to SQL2008 compatibility mode...

Is it as simple as going to the drop down and going straight to SQL 2008? Obviously i must test first but is threre anything else i need to do or look out for...

Testing... Just make sure the AX still works? How can i test?



Sharepoint 2010 DBs Installed on SQL 2008 r2 With Compatibility Level of 90


We installed Sharepoint 2010 using SQL 2008 r2 and had most databases install with a compatibility level of 100.  However two of the databases relating to User Profile Service SynchBD installed with a compatiblity level of 90.  Why would the Sharepoint install do that?  thx!

Compatibility of SQL server 2005 Dlls with SQL Server 2008 Dlls



I have  added SQL Server 2008 Dlls as a reference in Visual Studio 2005 C# .Net code.My requirement is my application should run for both Sql 2005 as well as Sql 2008.

But the application is not working for SQL 2005.

Can anyOne knows whether  SQL Server 2008 Dlls are backward compatible with SQL Server 2005.



Will full or differential backup break LSN chain if compatibility level = 80 in SQL Server 2005/2008

My understanding is that full or differential backup will not break LSN chain starting in SQL Server 2005.  However, I'm not sure whether this applies to databases with compatibility level 80 in SQL Server 2005/2008 or not.

Compatibility issues between Microsoft Visual Studio 2005 and Windows Server 2008 R2


Dear sirs,

When I was installing SQL Server 2005 64 bit on Windows Server 2008 R2, I received a notice informing the software Microsoft Visual Studio 2005 has known compatibility issues with this version of Windows.

So how can I get around these problems?

I need to use Visual Studio 2005 to create the Integration Services packages.

Also, I need to migrate directories of Integration Services packages from a server with SQL Server 2005 32 bit on Windows Server 2003 32 bit for a server with SQL Server 2005 64 bit on Windows Server 2008 R2. How can I proceed to do this?

Thanks in advance.

Jose Luiz

Using Conditional Split data Transfer in SSIS 2008

This article uses the Integration Services Conditional Split Data Transformation element to filter and transfer data from a set of flat text files to SQL Server database table. The concept can be easily extended to apply to any other source or destination such as Microsoft Excel. This scenario is useful in creating denormalized database tables in a reporting and analysis situation.

Sql Server 2008 Tutorials

This Link Provides total Sql Server 2008 Tutorials

Seven reasons to care about SQL Server 2008 R2

Microsoft begins to fully realize its vision of SQL Server as an information platform and not "just" a database. Hence the main theme for this release -- at least according to Microsoft -- is self-service BI. The PowerPivot plug-ins for Excel 2010 and SharePoint 2010 are easily going to make the biggest splash of all the new features, not least because they're the most complete. But then, SQL Server 2008 R2 isn't strictly necessary for PowerPivot for Excel, which works with plenty of other data sources.

Building Re-Usable ASP.NET User Control and Page Libraries with VS 2008


I am having problems with a user control. I want my solution to have a separate project for holding my user controls.

The main project can get a reference to this user control project and can import this user control dll into my main project. 

Thanks in advance,

Dheeraj Mittal


Visual Web Developer 2008


I'm getting th error "unable to connect to the asp.net development server 2008"

It's been working fine for months and all the sudden.I'm fairly new at this so if you have a fix I will need details.



Visual Studio 2008 Memory problems


My memory in task manager reaches about 900,000K  and I don't know why it does this. Definately slows everything down, especially when I rebuild my tableAdapters, takes about 30 seconds sometimes to rebuild the project.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend