|
|
|
Right there with Babe
      
Group: General Forum Members
Last Login: Sunday, May 19, 2013 7:29 PM
Points: 769,
Visits: 214
|
|
|
|
|
|
SSC Veteran
      
Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:01 PM
Points: 215,
Visits: 609
|
|
How about the restore functions?
|
|
|
|
|
Right there with Babe
      
Group: General Forum Members
Last Login: Sunday, May 19, 2013 7:29 PM
Points: 769,
Visits: 214
|
|
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)
|
|
|
|
|
SSC Veteran
      
Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:01 PM
Points: 215,
Visits: 609
|
|
"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.
|
|
|
|
|
Right there with Babe
      
Group: General Forum Members
Last Login: Sunday, May 19, 2013 7:29 PM
Points: 769,
Visits: 214
|
|
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)
|
|
|
|
|
SSC Veteran
      
Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:01 PM
Points: 215,
Visits: 609
|
|
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.
|
|
|
|