How difficult is a Windows Server 2003 with MS SQL Server 2005 to Windows Server 2012 with MS SQL Server upgrade/migration ? If one can do a side-by-side upgrade (and has weeks or months to do it) can it be reasonably done in one jump ? Or should one first upgrade/migrate from Windows Server 2003/MS SQL Server 2005 to Windows Server 2008/MS SQL Server 2008 and then do another full upgrade to Windows Server 2012/MS SQL Server 2012 ? Trying to do an intermediate upgrade to Windows Server 2008/SQL Server 2008 seems to be a lot of extra effort (for not much return). Is there a Wizard that can upgrade from SQL 2005 to SQL 2012, and is the upgrade from MS SQL Server 2005 to MS SQL Server pretty straightforward for a full-time DBA and is that a reasonable upgrade path and task for a full time DBA ? TIA
This is actually a simple process and you can go directly from SQL Server 2005 to Windows Server 2012. The basic process is to install the MS SQL Server 2012 on a new server and then detach the database
Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied?
You can use SQL Server Initialize from Backup…