Is Vince Iacoboni still around?

  • I just downloaded his sp_ABBackupRestore.zip stored procedures that he created back in 1998. I started using them on a test server and they work really good. I would like to know if there is an updated version from his original post or if there is a new one for SQL Server 2005? I hope he's still around...

    Thank you.

  • I'm alive! I just noticed your question now though, sorry! Did you personally email me? If not, fire away...

  • Love this proc and use it all the time. Having issues running it on SQL 2008. Is it compatible, or is there a different version? Here is the error I am getting:

    RegQueryValueEx() returned error 2, 'The system cannot find the file specified.'

    Msg 22001, Level 1, State 1

    Msg 213, Level 16, State 7, Procedure xp_restore_filelistonly, Line 1

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

    Thanks

  • So... what's the link for the article/script?

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Clint,

    Sorry, I haven't had time to convert it to SQL 2008. I've gotten "this close" to installing 2008 on a test box here, but other day-job priorities have taken over. When I get it installed I will post an update.

    Vince

  • Jeff,

    I believe the reference was to this article.

    http://www.sqlservercentral.com/articles/Administering/moreintelligentbackupandrestore/2137/

    Love your work by the way.

    Vince

  • Yep... that's the one. And, after reading that bad boy, I have to say that the feeling is mutual, Vince. 🙂

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 7 posts - 1 through 6 (of 6 total)

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