How to identify 2005 vs 2000 backups

microsoft.public.sqlserver.server

16 Nov 2006 9:14 PM

Rob Diamant

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

16 Nov 2006 9:35 PM

Kevin3NF

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

Show quoteHide quote

"Rob Diamant" <robd***@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
>

Are all your drivers up to date? click for free checkup

16 Nov 2006 9:37 PM

Tibor Karaszi

RESTORE HEADERONLY will give you such information. Check of the SoftwareVersionMajor column.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/

Show quoteHide quote

"Rob Diamant" <robd***@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
>
>