Sunday, February 19, 2012

How to identify 2005 vs 2000 backups

Can anyone guide me on how to determine if a backup is a 2005 or 2000
database. Is there some identifier bytes I can look at to determine the
correct version.
I have no problem writing a utility to scan a backup file for the correct
info (if it is necessary)
TIA
Rob
On my 2000 server:
restore headeronly
from disk = 'C:\Program Files\Microsoft SQL
Server\MSSQL$SQL2000\BACKUP\Northwind.bak'
results:
SoftwareVersionMajor = 8
SoftwareVersionMinor = 0
SoftwareVersionBuild = 2039
Same in 2005
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Rob Diamant" <robdusi@.hotmail.com> wrote in message
news:u9vIGRcCHHA.144@.TK2MSFTNGP02.phx.gbl...
> Can anyone guide me on how to determine if a backup is a 2005 or 2000
> database. Is there some identifier bytes I can look at to determine the
> correct version.
> I have no problem writing a utility to scan a backup file for the correct
> info (if it is necessary)
> TIA
> Rob
>

No comments:

Post a Comment