|
|
|
Grasshopper
      
Group: General Forum Members
Last Login: Monday, July 23, 2007 2:31 PM
Points: 16,
Visits: 1
|
|
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.
|
|
|
|
|
Say Hey Kid
      
Group: General Forum Members
Last Login: Friday, May 03, 2013 11:50 AM
Points: 712,
Visits: 410
|
|
I'm alive! I just noticed your question now though, sorry! Did you personally email me? If not, fire away...
|
|
|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Thursday, January 31, 2013 2:37 PM
Points: 1,
Visits: 214
|
|
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
|
|
|
|
|
SSC-Dedicated
           
Group: General Forum Members
Last Login: Today @ 7:58 PM
Points: 32,893,
Visits: 26,764
|
|
|
|
|
|
Say Hey Kid
      
Group: General Forum Members
Last Login: Friday, May 03, 2013 11:50 AM
Points: 712,
Visits: 410
|
|
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
|
|
|
|
|
Say Hey Kid
      
Group: General Forum Members
Last Login: Friday, May 03, 2013 11:50 AM
Points: 712,
Visits: 410
|
|
Jeff,
I believe the reference was to this article.
http://www.sqlservercentral.com/articles/Administering/moreintelligentbackupandrestore/2137/
Love your work by the way.
Vince
|
|
|
|
|
SSC-Dedicated
           
Group: General Forum Members
Last Login: Today @ 7:58 PM
Points: 32,893,
Visits: 26,764
|
|
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."
For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
|
|
|
|