I have to move a 5 TB SQL Server 2008 database that has mirroring setup to a new server that will have SQL Server 2012 and always on AG setup.
I am wondering if detach/attach would be faster or backup/restore. The compressed split backup is about 1.2 TB.
I understand that detach/attach means database will not be available on the source.
Any advise on matters to consider, as this will be a first SQL Server upgrade for me.
Thanks as always to the DBA community.