I’ll be presenting at this months SQL Server User Group (UG) meeting of CACTUSS Central (www.cactuss.org) this upcoming Monday 9/19/2011. The location of the presentation is here. The abstract is below. Abstract In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not […]
Category Archives: SQL Server Presentations
I was reading Paul Randal and Kimberly Tripp’s discussions about Virtual Log Files (VLFs), found here. DBCC loginfo I found that performing a log backup will cause the active VLF to ‘rotate’ to the first VLF, freeing up the rest of the VLFs for maximum shrinkage. Uh, well, you know what I mean. In SQL […]