Monthly Archives: May 2016

Configuration Manager SQL Server Backup guidelines

  As previously documented, using native SQL Server backup for ConfigMgr recovery has been supported since CM 2012 Sp1 and later. SQL backups are the preferred technique for backing up the ConfigMgr for a number of reasons. Here is my … Continue reading

Posted in ConfigMgr, SQL Server, SQL Server 2012, SQL Server 2014 | 19 Comments

SQL Server Database Migration Checklist

This guide is meant to provide general recommendations for migrating SQL Server databases from one server to another. Always test database migrations (and subsequent application connectivity) in a lab environment prior to the actual migration. Note: Server name ‘SOURCE’ is … Continue reading

Posted in Migration, SQL Server, SQL Server 2012, SQL Server 2014 | 3 Comments