Archives
MS SQL: Automatically restore latest backup
Posted on September 11, 2017 Leave a Comment
A common need is to restore the latest production backup to a test system or user acceptance test system on a regular basis. Depending on your system (database) size this can be time consuming. You would prefer to have this done during the night right after the backups run. If you don’t have any third […]
Microsoft SQL Server Performance Basics (I/O Performance)
Posted on July 7, 2014 Leave a Comment
There are a lot of settings that you can tweak to get higher performance out of your Microsoft SQL Server. The most basic one is IO performance, i.e. disk performance. Usually when I talk to people about this I get the response that this is an art form and something that most techs don’t know […]
SQL error after upgrading from express
Posted on March 3, 2012 Leave a Comment
A few days ago I helped a client update there SQL 2008 Express installation to a real SQL 2008 R2 installation. They have been hitting the wall for the 4Gb database size limit for some time so it was really time. I installed the new instance on the server and all went well. I just […]
SQL transaction logs growing and growing and …
Posted on April 20, 2010 Leave a Comment
Problems with growing transaction logs on SQL servers is a common problem. But many admins doesn’t think twice about the problem, they just add more disk space. The transaction log is only needed when you want to do a restore to an other point then the last backup. So in many cases they are not needed […]
Hackviking aka Kristofer Källsbo 