InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 07:39:29 GMT20http://www.sqlservercentral.com/Forums/Topic7883-90-1.aspxwe use veritas software to copy transaction log, full and diff backups to tape. We do this nightly.Gregory Larsen, DBAIf you looking for SQL Server Examples check out my website at http://www.sqlserverexamples.comTue, 27 May 2003 19:41:00 GMTGreg Larsenhttp://www.sqlservercentral.com/Forums/Topic7883-90-1.aspxGreat article, should be included in any disaster recovery. What do you use to pick up the transaction log files and at what frequency?CheersJohn ZacharkanTue, 27 May 2003 13:55:00 GMTzach_johnhttp://www.sqlservercentral.com/Forums/Topic7883-90-1.aspxMy 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, DBAIf you looking for SQL Server Examples check out my website at http://www.sqlserverexamples.comMon, 26 May 2003 21:09:00 GMTGreg Larsenhttp://www.sqlservercentral.com/Forums/Topic7883-90-1.aspxGreg, 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,Linlintai_liu@yahoo.com Wed, 21 May 2003 19:07:00 GMTlocaladmhttp://www.sqlservercentral.com/Forums/Topic7883-90-1.aspxHey, I like the suggestions. More heads are better than one.Gregory Larsen, DBAIf you looking for SQL Server Examples check out my website at http://www.sqlserverexamples.comMon, 04 Nov 2002 09:26:00 GMTGreg Larsenhttp://www.sqlservercentral.com/Forums/Topic7883-90-1.aspxGreat! 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. Mon, 04 Nov 2002 05:21:00 GMTlgehttp://www.sqlservercentral.com/Forums/Topic7883-90-1.aspxHi 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. Mon, 04 Nov 2002 04:53:00 GMTKlaas-Janhttp://www.sqlservercentral.com/Forums/Topic7883-90-1.aspxComments posted to this topic are about the content posted at <A HREF=http://www.sqlservercentral.com/columnists/glarsen/streamliningtherecoveryprocess.asp>http://www.sqlservercentral.com/columnists/glarsen/streamliningtherecoveryprocess.asp</A>Sun, 03 Nov 2002 00:00:00 GMTGreg Larsen