Post reply

Is Vince Iacoboni still around?

  • November 17, 2005 at 12:26 pm

    #169753

    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.

  • December 9, 2005 at 11:03 am

    #608774

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

  • January 21, 2009 at 3:32 pm

    #930756

    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

  • January 21, 2009 at 8:02 pm

    #930859

    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)

  • January 22, 2009 at 6:30 am

    #931096

    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

  • January 22, 2009 at 6:32 am

    #931103

    Jeff,

    I believe the reference was to this article.

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

    Love your work by the way.

    Vince

  • January 22, 2009 at 12:05 pm

    #931371

    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