Due to a recent act of user stupidity, I've been tasked restoring a file from a backup of our SharePoint site, and due to management decisions, we don't have, and aren't going to get the ability to use a plugin for our SharePoint backups, making restoring files from SharePoint quite the ordeal.
(At the moment, I'm building up a new database server on old hardware so I can attach the site database and run a TSQL script to extract the file.)
Since I very much don't want to have to do this ever again, it looks to me like the best solution is to turn on versioning for all our sites' various document libraries, and before I go about writing this script, I was wondering if anyone had already written one, or had another quick-and-easy way to accomplish the same thing. I came across this blog post in my Googling, which convinced me that it's at least possible, but it uses PowerShell and is for SharePoint 2010, and we use SharePoint 2007 running on Server 2003 (without PowerShell installed).
Does anyone here have a solution that they think might work, or maybe even a different approach that might be beneficial?