April 14, 2005 at 6:02 pm
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/kKellenberger/sqlbackup30.asp
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
April 27, 2005 at 9:26 am
How about the restore functions?
April 27, 2005 at 10:26 am
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 Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
April 27, 2005 at 11:18 am
"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.
April 27, 2005 at 11:31 am
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 Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
April 27, 2005 at 2:29 pm
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.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy