Tag Archives: administration

Powershell – Copy the Latest Backup

Posted on December 29, 2014 by way0utwest

I got an email recently where someone asked me how they can refresh a dev environment with Powershell. I guess I’d written something about this in 2009, though that would have been for testing as Red Gate had already banned … Continue reading →

Posted in Blog | Tagged , , , , | 5 Comments

Drop and Recreate

Posted on December 15, 2014 by way0utwest

Those of you that manage replicated environments have learned to have one thing handy: a script that recreates your replicated publishers, distributors, and subscribers. I was reminded of my past needs for those scripts recently when I saw this post on … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Drop and Recreate

SQL Server Disk Space Emergencies

Posted on December 8, 2014 by way0utwest

One of the things I’ll see happen often with SQL Server instances is that the system will run out of space on a drive. This could be for a variety of reasons, some of which can be prevented, and some … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on SQL Server Disk Space Emergencies

Creating Placeholder Files

Posted on December 1, 2014 by way0utwest

I recently wrote about placeholders for disk space. While you can use any file, like large images, video, etc., I’ve found a really simple, easy way to build these files on Windows. Contig.exe There’s a sysinternals utility called Contig. You … Continue reading →

Posted in Blog | Tagged , | Comments Off on Creating Placeholder Files