Browse by Tags

• Best Practices
• VLDB

• Maintain Database Partial Availability

  In SQL Server 2005, the basic unit of availability is filegroups. A database can remain online as long as the primary filegroup and the transaction log are online. In addition, if a data file is damaged or missing, only its user-defined filegroup becomes Read More... Posted Monday, February 26, 2007 6:00 PM by Linchi Shea | 1 Comments Filed under: Recovery, VLDB

• Some VLDB Availability Tidbits

  When dealing with VLDB availability, I found it useful to keep in mind a set of simple and general guidelines. Let me highlight them here. 1. Identify VLDB Early in the Application Lifecycle The importance of this is rather self evident. But it is often Read More... Posted Tuesday, January 02, 2007 11:43 PM by Linchi Shea | 2 Comments Filed under: Best Practices, Recovery, VLDB