SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags Database Design, Resilience Rss

   Items 1 to 1 of 1   

Designing Databases for Rapid Resilience

As the volume of data increases, DBAs need to plan more actively for rapid restores in the event of failure. For this, the intelligent use of filegroups is important, particularly when the Enterprise Edition of SQL Server offers the hope of online restores. How, though, should you arrange your data on the different filegroups? What happenens if the primary filegroup gets corrupted? Why backup and restore indexes?  Read more...
By Additional Articles 2012/11/13 | Source: SimpleTalk | Category: resilience
Rating:  Rate this |   Briefcase | 2,917 reads
   Items 1 to 1 of 1