How to identity Sql server version from Backup file

• binutb

  SSCommitted

  Points: 1741

  More actions

  September 15, 2017 at 9:14 am

  #402490

  Hi,

  How to identity backup is taken form which version Sql server from Backup file

  Regards
  Binu

• Lowell

  SSC Guru

  Points: 323518

  More actions

  September 15, 2017 at 9:24 am

  #1959615

  the restore headeronly command can do what you are asking

  the results has a column named "SoftwareVersionMajor", and "SoftwareVersionMinor", where you can get things like 13,0 for SQL2016, for example

   
  RESTORE HEADERONLY
FROM DISK = N'E:\MSSQL\Backups\ProductionServer\MyDB\LOG\ProductionServer_MyDB_LOG_20170915_111000.trn' 
WITH NOUNLOAD;
GO

  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!

• binutb

  SSCommitted

  Points: 1741

  More actions

  September 15, 2017 at 9:59 am

  #1959625

  Hi,

  Below is output
  SoftwareVersionMajor    SoftwareVersionMinor    SoftwareVersionBuild
  13                                    0                                     4001

  that means version is SQL Server 2016

  Regards
  Binu

• September 25, 2017 at 2:31 am

  This was removed by the editor as SPAM