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
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
sql database recovery allows you to save critical data and avoid losing it.
ReplyDeleteTool recovers System Tables and User Tables, Stored Procedures, Views, User Defined Data Types and Functions.