Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Streamlining the Database Server Recovery Process Expand / Collapse
Author
Message
Posted Sunday, November 3, 2002 12:00 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, June 6, 2014 2:06 PM
Points: 1,040, Visits: 277
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/glarsen/streamliningtherecoveryprocess.asp

Gregory A. Larsen, MVP

Need SQL Server Examples check out my website at http://www.sqlserverexamples.com
Post #7883
Posted Monday, November 4, 2002 4:53 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 10, 2002 12:00 AM
Points: 135, Visits: 1
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.




Post #45394
Posted Monday, November 4, 2002 5:21 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, May 20, 2005 8:46 AM
Points: 90, Visits: 1
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.




Post #45395
Posted Monday, November 4, 2002 9:26 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, June 6, 2014 2:06 PM
Points: 1,040, Visits: 277
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

Need SQL Server Examples check out my website at http://www.sqlserverexamples.com
Post #45396
Posted Wednesday, May 21, 2003 7:07 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 12:14 PM
Points: 3, Visits: 219
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

lintai_liu@yahoo.com




Post #45397
Posted Monday, May 26, 2003 9:09 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, June 6, 2014 2:06 PM
Points: 1,040, Visits: 277
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

Need SQL Server Examples check out my website at http://www.sqlserverexamples.com
Post #45398
Posted Tuesday, May 27, 2003 1:55 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, August 21, 2013 3:41 PM
Points: 413, Visits: 323
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
Post #45399
Posted Tuesday, May 27, 2003 7:41 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, June 6, 2014 2:06 PM
Points: 1,040, Visits: 277
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

Need SQL Server Examples check out my website at http://www.sqlserverexamples.com
Post #45400
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse