How can SQL Server 2005 OnLine Piecemeal Restore improve availability?

Question 1:  How can SQL Server 2005 OnLine Piecemeal Restore improve availability? Question 2:  Can I recover a single object such as a table or specific partition(s) from a partitioned table? Answer:   The question is how to get the greatest flexibility, manageability, availability and recoverability for large databases.  Anytime you need to restore a… Read more

Deploying SQL Server 2005 with SAN #1

Deploying SQL Server 2005 with SAN #1   Prem Mehra and Mike Ruthruff   An often asked question is how to design and deploy SAN with SQL Server 2005. The question is frequently raised by installations that are either deploying SQL Server for the first time or are upgrading to SAN from direct attach storage…. Read more