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

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

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

Posted By:      Posted Date: August 30, 2010    Points: 0   Category :Sql Server
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 ??    

View Complete Post

More Related Resource Links

Problem connecting to SQL Server 2008 R2 Express from Access 2007

I have a problem with SQL Server 2008 R2 Express with MS Access 2007. I am running Windows 7 with 8 gigs memory. I installed SQL Server 2008 R2 Express. Do I now need to install SP1 because I am running with Windows 7? I can open SQL Server using the Management Screen but I cannot connect to MS Access 2007 using SQL Server Express as the database. When trying to connect to SQL Server from Access 2007, I keep getting the message that SQL Server 2005 cannot be found. It will not allow me to sign onto sql server 2008 stating that it cannot be found. Do I have to now run the SQL Server 2008 R2 Express SP1? Is there an upgrade to MS Access 2007 which will allow me to use SQL Server 2008 R2 Express?

Backup SQL Server 2008 R2 Restore on SQL 2008

I have a SQL Server 2008 R2 instance that I need to backup and restore onto a SQL 2008 instance. When I attempt to restore the back up (.bak) database from the R2 SQL server onto the SQL 2008 server I get the following message: 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. (Microsoft.SqlServer.Smo) How can i backup the SQL 2008 R2 database to be compatible with SQL 2008?Ian Ceicys

sql server 2008 r2 insatallation problem

when ever i am installing Sqlserver R2 in my machine(Config;intel core2 duo,xp sp3 os 2gb ram)the error will accur as follows xml generation file error and error code is 0x84b10001 can any one help me how to solve this problem

SQL Server 2008 R2 Installation Problem - The language ENU is not supported by this setup package.


I am trying to install SQL Server 2008 Standard R2 on a Windows Server 2008 R2 64bits machine (all updates applied)... 

I run the setup.exe on the command line and I get the following error :

The language ENU is not supported by this setup package.
An error occurred during the SQL Server 2008 R2 Setup operation.

Error result: -2067529698
Result facility code: 1220
Result error code: 30

For more information, review SQL Server 2008 R2 Setup logs in your temp folder.

There is no log generated.

My regional settings + locale are all English-US

Any ideas?



web.config connection string problem within VisualStudio 2010 to point to SQL Server 2008 R2 Develop


Hello All, I would appreciate any help with this.

I believe my problem exists within the web.config which already had code in it to connect to SQL Server Express 2008.

I uninstalled the SQL Server Express that came with Visual Studio 2010.

I installed SQL Server 2010 R2 Developer, and I'm able to connect via Management Studio and through Visual Studio's Server Explorer's Data Connections I am connected.

I did run aspnet_regsql.exe within the 4.0 folder in order to create the database with Microsoft Service Providers.

Here is the ServerName: USER-5529234649 

Here is the name of the DataBase:  StepByStepChapter9

Here is the name of the Connection within Visual Studio's Server Explorer's Data Connections:  user-5529234649.StepByStepChapter9.dbo

Here is the code I changed in the web.config:

<add name="ApplicationServices" c

SQL Server Compatibility problem while backup and restoring ????


Hi ...

SQL Server Compatibility problem.

1. I have taken backup from sql server 2008 R2 , it is not restoring in sql server 2005 ?

Wats the problem and how to solve this issue ??

2. I have taken sql server 2008 R2 database and log file (mdf and ldf). it is also not attaching in SQL server 2005.

Plz help me to solve this .....

Problem with SQL Server 2008 R2 installation.


Hi guys, I have msdn subscribtion account. I download SQL Server 2008 R2. I have problem with installation on one pc. His owner cleaned windows registry with some util. He deleted some SQL folder in Program files manually. On pc is installed Win7 Enterprise.

1. I start SQL installation center

2. Choose new installation

3. Install Setup install rules, alll rule are passed

4. Then I add product key

5. Install Setup support files and thats all, installation stop in  this place.


So I try repair installation (http://msdn.microsoft.com/en-us/library/cc646006(SQL.105).aspx). But it doesn’t help. I dont get any installation error.

1. It installed support rules, all are passed

3. Then I add product key

4. Install Setup support files and thats all, installation stop in  this place.

I am clueless, any advance ? How repair this?


If I check Microsoft SQL Server 2008 R2 Setup Discovery Report no product are installed.

Sample from log:

2010-10-26 20:41:51 Slp: Running Action: RunDiscoveryAction

Microsoft Sql Server 2008 r2 Login Problem


Hi guys....

              I am facing the problem to acess the Data Base.

              some time ago i am easily acess the data base by typing the server name(like and type the user id and password   from  web.config file but now i am find the error.like .

Login failed for user 'NSAdmin' (Microsoft Sql Server, Error:18456).

please anybody help me out to finding the solution of the problem asap.


SQL Server 2008 r2 Report Builder 3 problem with "landscape" orientation


 I am trying to format a report that is oriented in 'landscape'.  I have set the report properties page setup for 'landscape' but the program formats the report in 'portrait' mode.  The program recognizes the margin settings but does not recognize the 'landscape' orientation.  Has anyone else had this problem?

BackUP SQL Server 2008 r2 cluster using netBackup.


Dear all,

I have SQL Server 2008 r2 clusterd physically on two server.

I have installed a netbackup server on another server physically.

I have installed netbackup client on the two SQL Server nodes.

My Question is how to configure the netclient on the two nodes.??

Can anyone help me please.


Many Thanks



problem in installing SQL SERVER 2008 R2


I had sql server 2005, sql server 2008, and tried to install SQl server 2008 R2. I got this following error please help..........

unistalled sqlserver 2008 , still i got same error

Overall summary:
  Final result:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
  Exit code (Decimal):           -733426222
  Exit facility code:            1096
  Exit error code:               52690
  Exit message:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
  Start time:                    2011-04-11 15:53:29
  End time:&n

Install SQL Server 2008 R2 Enterprise on Windows Server 2008 R2 64 bit problem.



I am installing SQL Server 2008 R2 Enterprise Edition 64bit to Windows Server 2008 R2 standard (64bit) on VMware Virtual Machine.

The OS version is 6.1.7601 Service Pack 1 Build 7601. Processor value shows "Interl(R) Xeon(R) CPU.

On the "Installation Rules" page, it shows the status of "64-bit processor" and "64-bit operating system" are  is "Not applicable". Click the link to see details, it shows "... rule is not applicable based on your system configuration or selections.".

I have checked the forums, and see someone asked the same question but the answer was to ignore it. The installation was completed, but I can see both 32bit and 64bit folders (\Program Files (x86) and \Program Files) have files installed on "Microsoft SQL Server". So, I don't know it is exatly 64bit or mixed with 32bit and 64bit.

Is there anything wrong on my server's setting?


Xiaogang Zheng

Xiaogang Zheng

SMO.Backup Problem with Remote Server on Network [SQL Server 2008, VS2010]



The Below codes working fine while I create backup on SQL Server installed on same system. But When I try to take backup on Network, the backup says failure.

Really i can't understand. Just i changed the IP & I tried, but I get failure reply.

For that Any Ideas will be welcome.

 MyDTBaseName = "Supplier_Accounts"
    MyBckPth = "\\Unc_Path\Year_End_2010"
    PurDbName = MyBckPth + "\Sup_SQLSMO.bak"
    Dim MyServIp As String = ", 2745"
    Dim MyRemot_ServIp As String = ", 2745"
    Dim MyBackup As Microsoft.SqlServer.Management.Smo.Backup = New Microsoft.SqlServer.Management.Smo.Backup
    Dim MyServer As Microsoft.SqlServer.Management.Smo.Server = New Microsoft.SqlServer.Management.Smo.Server
    'Dim MyServer As Microsoft.SqlServer.Management.Smo.Server = New Microsoft.SqlServer.Management.Smo.Server(",2745")
    MyServer.ConnectionContext.ServerInstance = MyServIp
    MyServer.ConnectionContext.LoginSecure = False
    MyServer.ConnectionContext.Login = "sa"
    MyServer.ConnectionContext.Password = "123"
    MyBackup.Action = BackupActionType.Database
    MyBackup.Database = "Supplier_Accounts"
    MyBackup.Devices.Add(New BackupDeviceItem(PurDbName, DeviceType.Fi

SMO Backup failed using Sql Server 2008 R2



To do database backup with C# I am using the following code:

 Server myServer = new Server(new Microsoft.SqlServer.Management.Common.ServerConnection(lServer, lUserID, lPassword));
                Microsoft.SqlServer.Management.Smo.Backup oBackup = new Microsoft.SqlServer.Management.Smo.Backup();
                oBackup.Action = BackupActionType.Database;
                oBackup.Database = lDatabase;
                oBackup.Devices.Add(new BackupDeviceItem(mBackupFileName, DeviceType.File));
                oBackup.Initialize = true;
                oBackup.Checksum = true;
                oBackup.ContinueAfterError = true;
                oBackup.Incremental = false;
                oBackup.LogTruncation = BackupTruncateLogType.Truncate;

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.

Problem in Installation of SQL Server 2008


Dear All,

I have Sqlserver2008 setup.

It is work in wndows Xp.

But I have to Install it on Windows 7 ,during installation process it requires some patch and I am unable to get it.

Plz some buddy can help the same.


Rakesh gupta

Using SQL Server 2008 R2 client with Enterprise Library



I am modifying an existing application that uses SQL Server 2008 as the database and Enterprise Library 4.1 for Data Access .

What I need to do is to make it use the SQL Server 2008 R2 client to take advantage of out of the box failover capabilities.

Any idea how I can accomplish this?


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