Post reply

check the version of backup

  • June 27, 2011 at 5:00 am

    #389842

    hi

    can any one tell me how to check the version in which version the backup was taken from sql (2005 or 2008 or 2008 r2 or 2008 r2 version 1.xx.xx) so on.

  • June 27, 2011 at 5:51 am

    #1344429

    kumarramachandrarao (6/27/2011)

    hi

    can any one tell me how to check the version in which version the backup was taken from sql (2005 or 2008 or 2008 r2 or 2008 r2 version 1.xx.xx) so on.

    Use the restore headeronly.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • June 27, 2011 at 5:56 am

    #1344432

    and an example to save you a trip to BOL:

    RESTORE HEADERONLY

    FROM DISK='C:\Data\SandBox9090_081010.bak'

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • June 27, 2011 at 5:59 am

    #1344436

    ew even worse, the results don't have the version you'd expect, that i can see...it has an internal database version, that you need a secret decoder ring to figure out:

    http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/07/28/database-version-vs-database-compatibility-level.aspx

    The internal database versions for SQL aren't documented in the Books Online. However, thanks to Paul Randal (@PaulRandal) and his Q&A article in TechNet we have the following list:

    •SQL Server 7.0 databases have version number 515

    •SQL Server 2000 databases have version number 539

    •SQL Server 2005 databases have version number 611/612

    •SQL Server 2008 databases have version number 655

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • June 27, 2011 at 6:22 am

    #1344454

    Lowell there you are man!

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • June 27, 2011 at 10:32 pm

    #1344946

    thx for your quick reply it is work

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply