| Author |
How to identify 2005 vs 2000 backups
|
|
| Rob Diamant 2006-11-16, 7:12 pm |
| 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
| |
| Kevin3NF 2006-11-16, 7:12 pm |
| 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
>
| |
| Tibor Karaszi 2006-11-16, 7:12 pm |
| 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/
"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
>
>
|
|
|
|