Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Resilience Rss

   Items 1 to 3 of 3   
 

Handling Backups for Rapid Resilience

The backup and restore system in SQL Server hasn't changed a great deal over the years despite a huge growth in the typical size of databases. When disaster strikes, and an important service is taken offline while a restore is performed, there is often time to reflect on whether it might be possible to design databases for a more rapid recovery of the most critical parts of a database application.  Read more...
By Additional Articles 2012/12/12 (first published: 2012/11/26) | Source: SimpleTalk | Category: backups
Rating:  Rate this |   Briefcase | 1,839 reads

Handling Backups for Rapid Resilience

The backup and restore system in SQL Server hasn't changed a great deal over the years despite a huge growth in the typical size of databases. When disaster strikes, and an important service is taken offline while a restore is performed, there is often time to reflect on whether it might be possible to design databases for a more rapid recovery of the most critical parts of a database application.  Read more...
By Additional Articles 2012/12/12 (first published: 2012/11/26) | Source: SimpleTalk | Category: backups
Rating:  Rate this |   Briefcase | 1,839 reads

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,300 reads
   Items 1 to 3 of 3   
 
Tags
backups (1)    
database design (1)