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

SQL Backup 3.0 Expand / Collapse
Author
Message
Posted Thursday, April 14, 2005 6:02 PM


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: Thursday, August 7, 2014 11:40 AM
Points: 769, Visits: 246
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/kKellenberger/sqlbackup30.asp

Aunt Kathi
Microsoft
(Former SQL Server MVP)
Post #174905
Posted Wednesday, April 27, 2005 9:26 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 3:56 PM
Points: 228, Visits: 702
How about the restore functions?


Post #177973
Posted Wednesday, April 27, 2005 10:26 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: Thursday, August 7, 2014 11:40 AM
Points: 769, Visits: 246

Just like the backups, you can use the wizard or script.  The restores worked fine.  The coolest feature was the ability to restore all log backups in a folder with one command.

 

 



Aunt Kathi
Microsoft
(Former SQL Server MVP)
Post #178011
Posted Wednesday, April 27, 2005 11:18 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 3:56 PM
Points: 228, Visits: 702
"Restore all log backups in a folder within one command" is really useful in real world, esp. when you have to do the "recovery to the point". I once implemented this function through a complex t-sql SP before, maybe I should share with people here about how I implement this just to save a few $'s to purchase the off-shelf package.


Post #178030
Posted Wednesday, April 27, 2005 11:31 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: Thursday, August 7, 2014 11:40 AM
Points: 769, Visits: 246
I am using log shipping to replicate one database.  When log shipping breaks, I have a VBScript that creates my log restore script for me to get it caught up again.

Aunt Kathi
Microsoft
(Former SQL Server MVP)
Post #178038
Posted Wednesday, April 27, 2005 2:29 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 3:56 PM
Points: 228, Visits: 702
Log shipping is fine, but more often than not, people do not have the budget to replicate a huge-sized db, which is not adding any economic value.


Post #178095
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse