i have requirement to migrate DB from On-premise SQL Server 2008 SP1 Enterprise Edition to Azure SQL MI using Azure DMS. We are planning to use online DMS as database size is big. For online DMS, we need enable checksum on Log backup but checksum option is not displayed on 2008 SQL server.
I updated SSMS to newer edition but that too doesn't show "Checksum option".
I run below SQL script to take log backup with checksum but it's not working.
BACKUP LOG [ReportServer] TO DISK = N'C:\reportserver.trn' WITH NOFORMAT, NOINIT, NAME = N'ReportServer-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10, CHECKSUM GO