Archives

“That’s Not My Job” One Other Maintenance Plan Issue

Not My Job

Experienced M2M Administrators may have noticed something consipicously absent from my article on maintenance plans. I either skipped it intentionally to make a point or forgot because I have the attention span of a gnat, I’ll let you speculate the reason amongst yourselves.

As of now, all versions of Made2Manage since 3.X [...]

SQL Server Maintenance Plans for Small/Mid-sized Businesses

I get a ton of questions and calls about SQL Server Maintenance issues from Administrators who just want their server to work and be protected. They’re not interested in the intricate structure of a transaction log, how to use wait stats, etc. While many database administrators who read this article will disagree or perhaps outright [...]

A Wake-Up Call

Last night I received a call from a independent M2M Consultant who needed help with a transaction log that was growing too large. One of the reasons I have this blog is to find others with skills which complement mine. I like to think of us as a group of rebel soldiers with various roles [...]

Trust No One

Something happened at work this week, which put a fine point on the current theme of most of my articles, which is preparedness; being able to recover from a disaster.

I currently support two different business units which use M2M, each separated by approximately 1400 miles. Yesterday morning we started getting reports of computers at [...]

SQL Server Recovery Models and Backup Types

This is the fourth of a series of articles discussing backup and recovery for M2M businesses.

Once again, I’m giving you a very high level overview of these concepts and I am not going to cover every option available, only those which are important to companies that use M2M. If you want to dig [...]

Compressing and Encrypting Your Backups

In the last article in this series, I discussed the commonly used options for Backup options and stressed that off-site backup were critical for disaster recovery. However, I also pointed out that the size of your backups combined with how many past backups you need to retain can be cost prohibitive. In this article, I’ll [...]

Disaster Recovery Options for Small/Medium Sized Businesses

This is the second of a series of articles, regarding disaster recovery for the small/medium sized businesses which are the typical customers of Made2Manage. All of these articles will be at a high level with links to more in depth articles where you can read about all the gory details.

What are we trying to [...]

That's it man, game over man, game over! What the &%$ are we gonna do now?

I regularly receive questions about backup and recovery. A particularly troubling message I received recently prompted me to create the polls on database backup and recovery. I decided to create a short series of articles on disaster recovery for the small/medium sized businesses that typically use Made2Manage. This article is a true story [...]