What are the challenges you face when working across database platforms? Take the survey
Options

How to open a .bak file compressed?

Is there a way to open a compressed .bak file?
if answer is no what product do you have for me to open a compressed .bak file?

Whats is my best alternative?

Best regards
Tagged:

Answers

  • Options
    Eddie DEddie D Posts: 1,789 Rose Gold 5
    Hi, thank you for your post.

    To answer your question:
    Is there a way to open a compressed .bak file?  if answer is no what product do you have for me to open a compressed .bak file?

    I assume you mean a native SQL Server compressed backup file.  Sadly the answer is no, our tools cannot decompress a native SQL Server compressed backup file.

    Whats is my best alternative?

    Restore the backup file to a test database or if possible connect to the database that created the backup file as the data source to perform your comparison.

    Obtain an uncompressed  native SQL Server backup file and use this *.bak file as one of your data sources.

    Sorry, the Redgate Comparison and backup tools cannot read a native SQL Server compressed backup file.

    Many Thanks
    Eddie


    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.