• pakwichek (11/10/2011)


    Hello Sir,

    I am using SQL 2008 and this beautiful script should help me a great deal as we are migrating from SQL 2008 and SQL 2008 R2

    I keep getting the error

    Msg 213, Level 16, State 7, Line 1

    Column name or number of supplied values does not match table definition.

    Msg 3013, Level 16, State 1, Line 1

    Msg 213, Level 16, State 7, Line 1

    Column name or number of supplied values does not match table definition.

    Msg 3013, Level 16, State 1, Line 1

    RESTORE HEADERONLY is terminating abnormally.

    Msg 213, Level 16, State 7, Line 1 is terminating abnormally.

    Msg 213, Level 16, State 7, Line 1Which I think it might the output of RESTORE HEADERONLY does not fit into the scheme defined? Do you have updated script for SQL 2008?

    Please help

    Greatly appreciated

    Hi kindly view page 5 of this thread post of Steven Webster-494809 or stakes 🙂

    P.S.

    Ohh another thing, I think I browsed an article regarding incompatibility of SQL 2008 restoration to SQL 2008 R2 (or vice versa). I maybe wrong but it will not hurt you to just check and verify

    "-=Still Learning=-"

    Lester Policarpio