question

SarveshPandey-7139 avatar image
1 Vote"
SarveshPandey-7139 asked ·

Take backup on SQL Server 2008 SP1 with checksum

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  


azure-sql-database
· 1
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@SarveshPandey-7139 Please let us know if you need further help.

0 Votes 0 ·

1 Answer

AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered ·

Please use trace flag 3023 to enable the CHECKSUM option as explained in **this** Microsoft Support article.




·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.