|
|
|
Right there with Babe
      
Group: General Forum Members
Last Login: Friday, May 31, 2013 2:54 PM
Points: 769,
Visits: 216
|
|
|
|
|
|
SSC Veteran
      
Group: General Forum Members
Last Login: Wednesday, June 05, 2013 3:33 PM
Points: 215,
Visits: 613
|
|
How about the restore functions?
|
|
|
|
|
Right there with Babe
      
Group: General Forum Members
Last Login: Friday, May 31, 2013 2:54 PM
Points: 769,
Visits: 216
|
|
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: Wednesday, June 05, 2013 3:33 PM
Points: 215,
Visits: 613
|
|
"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: Friday, May 31, 2013 2:54 PM
Points: 769,
Visits: 216
|
|
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: Wednesday, June 05, 2013 3:33 PM
Points: 215,
Visits: 613
|
|
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.
|
|
|
|