File Group backups are great when working with very large databases (VLDB’s) that have been partitioned. Typically when I come across File Group backups implemented in production the database is using the full recovery model. With the full recovery model you can specify individual file groups for backup. A very common backup strategy for VLDB’s […]
Category: SQLServerPedia Syndication
How to check for last SQL Server backup
As a database professional, I get asked to review the health of database environments very often. When I perform these reviews, one of the many checks I perform is reviewing backup history and making sure that the backup plans in place meet the requirements and service level agreements for the business. I have found a […]
Recovering the tail end of the transaction log
Knowing a great deal about backup and recovery is key to any DBA’s career. Most of us fully understand the recovery models, recovery point objectives and recovery time objectives. What I have found from speaking at many SQL Saturday’s and User Groups is that most DBA’s do not regularly practice recovery strategies. It is very […]
PASS Elections part two
Tim Ford is running for a seat on the PASS Board of Directors and has my vote. Yes I think we need to have a “TIM” on the Board of Directors. 🙂 I have known Tim for a few years now. We have attended numerous events together over the years and contributed to a number […]
PASS Elections
I as well as many others have a decision to make on who I am voting for the PASS Board of Directors. I haven’t made my mind up completely for all the votes I get to cast but one vote for sure is for Allen Kinsel. Why is my mind made up for Allen you […]
Get OS Counter Memory Available Mbytes Using TSQL
I have been working recently in making sure that max memory is configured for the hundred plus database servers I support. In reading numerous books, blog post and attending various talks on memory management people reference the OS memory counter “Available Mbytes” a lot. Various references state that this value should be between 150 and […]
Professional Etiquette When Sending Mass Email – Use BCC:
<begin soap box rant> Time and time again I find myself having to email people to remind them about how and when to use BCC when sending out correspondence to a huge group via email. The main rule of thumb I tell the senders is that if dialog is not needed between everyone on the […]
Cannot create Cluster – the computer X is joined to a cluster
Recently attempting to install a new three node cluster I ran into a new issue. Once I was able to run a successful “Cluster Validation Check” and chose the option to install a new cluster I received a message “The computer xxx is joined to a cluster”. My first thought then was to […]