Archive for January, 2014

How to change the location of the Default Trace Files?

I had a situation where a 500 GB drive needed to be repurposed and the…oh 20GB worth of databases on it needed to be moved somewhere else. I found a blog post on sqlconcepts that indicates you can’t change default settings for the default trace. Luckily while that is true of the size or the number of files retained, it is a relatively simple matter to change the location.

Read More →