Post reply

Identify SQL Server backup files

  • April 4, 2008 at 8:24 am

    #180878

    How to identify the backup files, whether the backup files were taken using SQL 2000 or SQL 2005 without restoring it on the database?

    Advance thanks,

    Ravi

    Regards,
    Ravi.

  • April 4, 2008 at 8:45 am

    #798491

    Ravi Kumar (4/4/2008)

    How to identify the backup files, whether the backup files were taken using SQL 2000 or SQL 2005 without restoring it on the database?

    Advance thanks,

    Ravi

    Use "restore headeronly". This does not restore the database backup, just reads the header information. Look at the column: SoftwareVersionMajor. If it is 9, then it was SQL Server 2005, if it is 8, then it was SQL Server 2000.

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

  • April 4, 2008 at 9:36 am

    #798540

    I'd do what Andras selected.

    If you're on the server, there is a certain amount of backup history kept as well that you can query in msdb.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply