Home Forums SQL Server 2008 SQL Server 2008 - General Read a backup file to find the version RE: Read a backup file to find the version

  • March 7, 2013 at 7:03 am

    #1594428

    easy peasy!

    The error could be on my side, or maybe something is different on my backups that you should double check against.

    !edit!

    something i was thinking: my 2008/2008R2/2012 backups are on a disk that is formatted with 4k sectors instead of the "normal" 512 sectors! that might be the difference!

    for my 2008R2 for example, i created a brand new database CodeTest, and did a normal backup via the GUI:

    the scripted command is:

    BACKUP DATABASE [CodeTest] TO DISK = N'F:\SQLData\SQL2008R2\Backup\CodeTest.bak'

    WITH NOFORMAT,

    NOINIT,

    NAME = N'CodeTest-Full Database Backup',

    SKIP,

    NOREWIND,

    NOUNLOAD,

    STATS = 10

    GO

    i did exactly that code in all 4 version i have available to me.

    here is a link to a zip file with all four empty databases, each one created on one of my servers or local instances:

    so you can test it on your side:

    CodeTest2005.bak

    CodeTest2008.bak

    CodeTest2008R2.bak

    CodeTest2012.bak

    Four SQL Backups CodeTestDBs.zip 729kb zip/6 meg uncompressed

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!