| Author |
SQL Server Build Numbers
|
|
| mobcdi 2005-10-12, 11:23 am |
| I was trying to restore my master db that I took immediately before I had to
reinstall the server from bare metal and ran into the error of "System
Database Backups Cannot be Restored on a Different Build of SQL Server". I
found the article http://support.microsoft.com/Default.aspx?id=264474 about
what to do but I'm not able to find anywhere that tells me what the server
build numbers correspond to. My original server was 134218546 and my new
server is 134219767 even though I thought I had the original server fully
patched. Anyone able to tell me where to find what the build numbers mean
--
Michael
| |
| Jacco Schalkwijk 2005-10-12, 11:23 am |
| As far as I know there is no direct mapping available from the 9 digit build
numbers that are reported in the error message, and the version numbers that
are publicly available. However, as the article mentions, you can get the
version number for the backup file using RESTORE HEADERONLY and for the
server with SELECT SERVERPROPERTY('Prod
uctVersion').
You can than look up the version numbers at the following link
http://www.aspfaq.com/show.asp?id=2160
and determine to which Service pack and hotfixes you have to rebuild.
--
Jacco Schalkwijk
SQL Server MVP
"mobcdi" <@news.postalias> wrote in message
news:7C8BB321-297D-4F31-868F- 2BE271B36263@microso
ft.com...
>I was trying to restore my master db that I took immediately before I had
>to
> reinstall the server from bare metal and ran into the error of "System
> Database Backups Cannot be Restored on a Different Build of SQL Server". I
> found the article http://support.microsoft.com/Default.aspx?id=264474
> about
> what to do but I'm not able to find anywhere that tells me what the server
> build numbers correspond to. My original server was 134218546 and my new
> server is 134219767 even though I thought I had the original server fully
> patched. Anyone able to tell me where to find what the build numbers mean
> --
> Michael
| |
| Lori Clark 2005-10-12, 11:23 am |
| I'm not sure what the numbers are that you list below, but here's an article
that explains SQL Server versions. Any numbers between the ones listed for
service packs are some type of hotfix or security patch (e.g. 8.00.952)
http://support.microsoft.com/defaul...kb;en-us;321185
"mobcdi" <@news.postalias> wrote in message
news:7C8BB321-297D-4F31-868F- 2BE271B36263@microso
ft.com...
>I was trying to restore my master db that I took immediately before I had
>to
> reinstall the server from bare metal and ran into the error of "System
> Database Backups Cannot be Restored on a Different Build of SQL Server". I
> found the article http://support.microsoft.com/Default.aspx?id=264474
> about
> what to do but I'm not able to find anywhere that tells me what the server
> build numbers correspond to. My original server was 134218546 and my new
> server is 134219767 even though I thought I had the original server fully
> patched. Anyone able to tell me where to find what the build numbers mean
> --
> Michael
| |
| Kevin3NF 2005-10-12, 11:23 am |
| From the article:
You can determine the build on which the backup occurred by using the
following command on the backup file:
RESTORE HEADERONLY
FROM DISK = 'd:\temp\master176.bak'In the output that is generated, the
following three (3) columns provide the server build information:
SoftwareVersionMajor
SoftwareVersionMinor
SoftwareVersionBuild
-------------------- -------------------- --------------------
8 0 176
The actual output has several other columns; however, only the columns that
are of interest are included in this article for clarity.From
there:http://www.aspfaq.com/show.asp?id=2160to determine which hotfixes and
such you need
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"mobcdi" <@news.postalias> wrote in message
news:7C8BB321-297D-4F31-868F- 2BE271B36263@microso
ft.com...
>I was trying to restore my master db that I took immediately before I had
>to
> reinstall the server from bare metal and ran into the error of "System
> Database Backups Cannot be Restored on a Different Build of SQL Server". I
> found the article http://support.microsoft.com/Default.aspx?id=264474
> about
> what to do but I'm not able to find anywhere that tells me what the server
> build numbers correspond to. My original server was 134218546 and my new
> server is 134219767 even though I thought I had the original server fully
> patched. Anyone able to tell me where to find what the build numbers mean
> --
> Michael
| |
| mobcdi 2005-10-17, 1:23 pm |
| Thanks to everyone who posted. I did post a bit early without fully reading
the article but thanks for the links that say what minor version numbers were
as a result of a certain update. I managed to restore all my dbs from the
backup I had taken and patch the server to SP4.
Thanks again
--
Michael
"Kevin3NF" wrote:
> From the article:
>
> You can determine the build on which the backup occurred by using the
> following command on the backup file:
> RESTORE HEADERONLY
> FROM DISK = 'd:\temp\master176.bak'In the output that is generated, the
> following three (3) columns provide the server build information:
> SoftwareVersionMajor
SoftwareVersionMinor
SoftwareVersionBuild
> -------------------- -------------------- --------------------
> 8 0 176
>
> The actual output has several other columns; however, only the columns that
> are of interest are included in this article for clarity.From
> there:http://www.aspfaq.com/show.asp?id=2160to determine which hotfixes and
> such you need
> --
> Kevin Hill
> President
> 3NF Consulting
>
> www.3nf-inc.com/NewsGroups.htm
>
>
> "mobcdi" <@news.postalias> wrote in message
> news:7C8BB321-297D-4F31-868F- 2BE271B36263@microso
ft.com...
>
>
>
|
|
|
|