Knowledge Document: MS SQL restore fails with "Filemark on device 'Data Protector_id is not aligned"

Caroline Oest OpenText Employee

0 Likes

1 month ago

MS SQL restore fails on some backups because of SQL backup sets blocksize mismatch, which can be worked around in DP.

Environment

DP: any
Platform: any

Situation

MS SQL restore fails with an error:

Major] From: OB2BAR_SQLBAR@g8w11554c.auth.hpicorp.net "I01"  Time: 11/18/2024 2:51:30 PM
	Error has occurred while executing a SQL statement.
	Error message: 'SQLSTATE:[42000] CODE:(3284) MESSAGE:[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Filemark on device 'Data Protector_I01_DASPRO_095042302_0' is not aligned. Re-issue the Restore statement with the same blocksize used to create the backupset: '65536' looks like a possible value.
SQLSTATE:[42000] CODE:(3241) MESSAGE:[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The media family on device 'Data Protector_I01_DASPRO_095042302_0' is incorrectly formed. SQL Server cannot process this media family.

Cause

Backup and restore SQL blocksizes mismatch.

See full knowledge document on support portal

Tags:

Data Protector

backup and recovery

SQL blocksize

Labels:

Support Tips/Knowledge Docs

Comment List

Recommended

Menu

Data Protector Tips