Unable to get PFS page for page ID xxx

I've run a redgate sql pro backup, tested the backup by restoring to another server...

but when trying to run sql data compare between the backup file and the live database, we get the message

"error Unable to get PFS page for page ID xxx"

This happens with any database


  • Alex BAlex B Posts: 944 Diamond 3
    Hi @Mike_Vessey77,

    I've just been in touch via a support ticket to gather further information as my initial test of this backing up a simple SQL 2017 database with compression level 4 and encryption with a 256-bit key is working as a target in SQL Compare version 13.7.12.

    I will update here once we have progressed the investigation via the ticket!

    Kind regards,
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
Sign In or Register to comment.