November 3, 2002 at 12:00 am
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/glarsen/streamliningtherecoveryprocess.asp
Gregory A. Larsen, MVP
November 4, 2002 at 4:53 am
Hi Greg great article, i think it will save a lot of time. I like the concept of first building the sql before executing. I think it would be nice to have the option to only generate scripts for one database (with an optional parameter) or for all databases.
November 4, 2002 at 5:21 am
Great! I like the idea to use current msdb to create restore scripts on the spot. I suggest you include the possibility to handle several backup files for one database restore plus the possibility to MOVE files to another location.
November 4, 2002 at 9:26 am
Hey, I like the suggestions. More heads are better than one.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.sqlserverexamples.com
Gregory A. Larsen, MVP
May 21, 2003 at 7:07 pm
Greg, your approach works good in the scenario that you have put dump files in same directory where they were backed up. My suggestion is, if you can detect where they are and how many they are based on actual files, that will be great. For example, I have a DB dump and a bunch of tran log dumps in some where in harddisk. I want to restore those to a database and wish your script to generate a series of "restore" command in order. Would it be something you consider as valid request?
Regards,
Lin
May 26, 2003 at 9:09 pm
My approach reads the system tables to determine where the backups are. Now if you move the backup files to another drive then this is not recorded in the system tables, and would make it harder to write a script to find them. I suppose the script could be easily modified if you always have a specific directory in which you moved the backups, and you kept the backup name the same. Is this your case?
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.sqlserverexamples.com
Gregory A. Larsen, MVP
May 27, 2003 at 1:55 pm
Great article, should be included in any disaster recovery. What do you use to pick up the transaction log files and at what frequency?
Cheers
John Zacharkan
John Zacharkan
May 27, 2003 at 7:41 pm
we use veritas software to copy transaction log, full and diff backups to tape. We do this nightly.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.sqlserverexamples.com
Gregory A. Larsen, MVP
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply