Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

SQL Server version identification

Created: 06 Sep 2012

I'm doing some work with the NetBackup SQL Server agent and am trying to identify the version of SQL server which ran on the client when the backup was taken.

I can use the bplist command to generate the following:

server.MSSQL7.server\instance.db.dbname.~.7.001of001.timestamp..C

From the documentation, I was under the impreassion that the MSSQL7 was the version of SQL server which the backup came from. However, I've been using SQL Server 2000 and SQL Server 2005 and both of these report MSSQL7, is there any way that I can identify the versions of the SQL Server which was the source for the backup?