Blog Pages

RESTORE HEADERONLY - get the backup header information

RESTORE HEADERONLY FROM DISK = 'D:\tempItai\Itai.bak'

Returns a result set containing all the backup header information for all backup sets on a particular backup device.
This is not RESTORE - only SELECT.



In order to find the DB version from the integer in DatabaseVersion column:

No comments:

Post a Comment