November 17, 2005 at 12:26 pm
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
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
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
So... what's the link for the article/script?
--Jeff Moden
Change is inevitable... Change for the better is not.
January 22, 2009 at 6:30 am
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
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
Yep... that's the one. And, after reading that bad boy, I have to say that the feeling is mutual, Vince. 🙂
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply