Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««12345»»»

More Intelligent Backup and Restore Expand / Collapse
Author
Message
Posted Wednesday, July 19, 2006 6:59 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 2:10 PM
Points: 716, Visits: 466
Herman,

Sorry, no. Job time constraints and family responsibilities leaves me not enough time to finish. At this point I wouldn't hold your breath...

Vince



Post #295483
Posted Wednesday, July 19, 2006 7:27 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 7, 2008 2:26 PM
Points: 12, Visits: 7

I have modified the scripts quite a bit and I have log file backups scripted.  I was not too concened about log file restores because any DR will have a lot of hands on attention and scripts will more than likely not be used.

My scripts are chopped up quite a bit.  I also added some additional features.  If anyone wants to my scripts to clean them up, document and publish them, let me know and I will send them to you.

Kevin

Post #295492
Posted Friday, August 4, 2006 3:29 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 23, 2007 2:31 PM
Points: 16, Visits: 1

I donwloaded the scripts from Phil Cruz
(http://philcruz.com/blog/2006/04/more-intelligent-backup-and-restore.htm)

The Backup part works like a charm but when I tried to run the Restore part I got the following error:

THIS IS WHAT I AM TRYING TO RESTORE
EXEC sp_ABRestoreDb 'dnndb', 'c:\Temp\dnndb.BAK'

THIS IS THE ERROR
RegQueryValueEx() returned error 2, 'The system cannot find the file specified.'
Msg 22001, Level 1, State 1
Msg 213, Level 16, State 7, Line 1
Insert Error: Column name or number of supplied values does not match table definition.
Msg 3013, Level 16, State 1, Line 1
RESTORE FILELIST is terminating abnormally.
Msg 50000, Level 16, State 1, Procedure sp_ABRestoreDb, Line 458
Couldn't restore database dnndb from file c:\Temp\dnndb.BAK since the number/type of logical devices do not match.


Any Ideas ????

Post #299765
Posted Monday, August 7, 2006 7:46 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 2:10 PM
Points: 716, Visits: 466
Luis,

I didn't know the scripts were posted on Phil Cruz's blog. The link seems broken when I try it. Have you tried following the link from the article (the original source code)? If that doesn't work reply here and I should be able to help.

Vince



Post #299934
Posted Monday, August 7, 2006 9:29 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 23, 2007 2:31 PM
Points: 16, Visits: 1

Vince,
As allways, thank you very much for your help. Here is the link to Phil Cruz's website. It should work this time.

I downloaded your original source code and have been using it for a while. When I upgraded to SQL 2005, I started to get errors and found Phil Cruz's fixes.

http://philcruz.com/blog/2006/04/more-intelligent-backup-and-restore.htm

Do you have a newer version that supports SQL 2005?

Thanks

Post #300037
Posted Thursday, August 10, 2006 8:55 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 23, 2007 2:31 PM
Points: 16, Visits: 1

Hey Vince, still around?

I was wondering if you have a newer version that supports SQL Server 2005. I tried to "fix" the issue myself but my little brain doesn't get that far.

Thanks.

Post #300925
Posted Thursday, August 10, 2006 9:17 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 2:10 PM
Points: 716, Visits: 466
Luis,

Yes, still here and watching the thread. I need a week or so to clean this up, but haven't been able to get the time. The day job is demanding lately.

Along with SQL 2005 improvements, I need to handle the next version of SQLBackup. They really messed me up by returning two result sets, the first one with one column and the second with two. There's no way to EXEC ... INSERT that into a table, so there's no great solution at this point.

Anyway, I will post when I get a chance to update it...

Vince



Post #300933
Posted Monday, August 14, 2006 7:43 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 23, 2007 2:31 PM
Points: 16, Visits: 1

Vince,

Thank you for your reply. I'll be watching this thread anxiously for any updates you may have.

Post #301533
Posted Tuesday, August 29, 2006 4:17 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 23, 2007 2:31 PM
Points: 16, Visits: 1

Hi Vince, I just wanted to know if you have any updates on your scritps to support SQL Server 2005, mainly the Restore one.

Thanks!

Post #304846
Posted Wednesday, August 30, 2006 6:11 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 2:10 PM
Points: 716, Visits: 466
Luis, what I have isn't ready for general publication, but it kinda works. Send your personal email to me at my first name dot my last name at gmail dot com and I will send you what I have.

Sorry, just too busy these days to finish it off.



Post #304928
« Prev Topic | Next Topic »

Add to briefcase «««12345»»»

Permissions Expand / Collapse