Friday, June 1, 2012

Get SQL Server database backup version

Use below query to get the version of SQL Server database backup:

Restore Headeronly from Disk='C:\Temp\Data.bak'

Now you can get the version information by concatenating three columns in the query result. Which are:

SoftwareVersionMajor, SoftwareVersionMinor, SoftwareVersionBuild

1 comment:

  1. sql database recovery allows you to save critical data and avoid losing it.

    Tool recovers System Tables and User Tables, Stored Procedures, Views, User Defined Data Types and Functions.