Search

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.

    ReplyDelete