March 31, 2011 at 1:46 am
I have two servers running sql 2008 r2 as follows:-
Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (X64) Sep 16 2010 19:43:16 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (VM)
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 6.1 <X64> (Build 7600: ) (Hypervisor)
As you can see that their versions are not the same.
The challenge i am having is to do with backup and restore. The restore is failing with a message telling me about the Backup had been backed up using a diferent sql version and canoot be restored. to be exact :"System.Data.SqlCient.SqlError: The database was backed up on a server running version 10.50.1600. The version is incampatible with this server, which is running 10.00.4000."
how can i restore this databaese successfully, i need to to this for mirroring. Please help.
March 31, 2011 at 2:10 am
THE-FHA (3/31/2011)
I have two servers running sql 2008 r2 as follows:-Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (X64) Sep 16 2010 19:43:16 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (VM)
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 6.1 <X64> (Build 7600: ) (Hypervisor)
As you can see that their versions are not the same.
The challenge i am having is to do with backup and restore. The restore is failing with a message telling me about the Backup had been backed up using a diferent sql version and canoot be restored. to be exact :"System.Data.SqlCient.SqlError: The database was backed up on a server running version 10.50.1600. The version is incampatible with this server, which is running 10.00.4000."
how can i restore this databaese successfully, i need to to this for mirroring. Please help.
If you look closely they are not both SQL Server 2008 R2. The first instance is SQL Server 2008. You need to upgrade this instance to SQL Server 2008 R2.
March 31, 2011 at 2:21 am
Oh ok.
but cant you jst upgrade 10.00.4000 to 10.50.*** without having to upgrade the entire server or that would still give issues? Isnt there a CU for this to be compatible with other versions (jst out of curiosity)?
March 31, 2011 at 2:58 am
THE-FHA (3/31/2011)
Oh ok.but cant you jst upgrade 10.00.4000 to 10.50.*** without having to upgrade the entire server or that would still give issues? Isnt there a CU for this to be compatible with other versions (jst out of curiosity)?
There is no CU that will allow you to restore a SQL Server 2008 R2 database to a SQL Server 2008 instance. You either have to upgrade the particular instance on the server running SQL Server 2008 or write a set of SSIS packages that will move the data from the SQL Server 2008 R2 database to a SQL Server 2008 database.
March 31, 2011 at 3:03 am
I just noticed that you are doing this for mirroring the database. I'm not a database mirroring expert, but I am pretty sure both servers need to be running the same version of MS SQL Server. Hopefully, someone with more knowldege in this area will see this and confirm or deny this requirement.
March 31, 2011 at 4:40 am
THE-FHA (3/31/2011)
Oh ok.but cant you jst upgrade 10.00.4000 to 10.50.*** without having to upgrade the entire server or that would still give issues? Isnt there a CU for this to be compatible with other versions (jst out of curiosity)?
You can just upgrade the 10.00 instance to 10.50. It involves buying a licence for SQL 2008 R2, then running the installer and selecting the upgrade option.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 31, 2011 at 4:42 am
Lynn Pettis (3/31/2011)
I just noticed that you are doing this for mirroring the database. I'm not a database mirroring expert, but I am pretty sure both servers need to be running the same version of MS SQL Server. Hopefully, someone with more knowldege in this area will see this and confirm or deny this requirement.
The only time mirroring with different versions is supported is during an upgrade process. To upgrade a SQL 2008 mirrored oair to SQL 2008 R2 you can first upgrade the mirror, then fail over, then upgrade the principal.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply