I’ve covered creating my backup directories and the actual backup of the database(s). The last thing I want to do in my process is clean up any old backup files. Once again, I want to allow for some flexibility in my procedure. Much like the maintenance plan task I’m replacing, my procedure should be able […]
Last time I dealt with the creation of subdirectories, in one or more root locations, to house my database backups. Today we’ll get into the meat of the database backup procedure itself. If you’ll recall, this procedure has to meet some specific criteria: It will need a minimum of tweaking to implement and maintain. It […]
Anyone who knows me knows that I’m a big proponent of automating routine tasks. If I have to do something more than twice, it should be scripted (if not fully automated). I’ve also made it fairly clear that I’m no fan of SSIS. So with all that in mind, it should be no surprise when […]
So, as I’ve mentioned in the past, I have an inventory database where I store information on our various SQL Server installations. It has instance data (versions, editions, patch levels, collation settings, etc), database information (compatibility level, creation date, collation, recovery model, the backup location, etc.), and more. I also use it to track database […]
Doh! A while back I posted a Powershell script that would script out a SQL Server database. Well, a reader pointed out to me yesterday that it wasn’t quite working for him. And wouldn’t you know, it wasn’t working for me either. The problem was that when I created the script I had a specific […]
