β09-06-2012 10:12 AM
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?