Link to home
Start Free TrialLog in
Avatar of jordanhelen
jordanhelenFlag for United States of America

asked on

Restore or open SQL Server 2008 BAK file.

I need to restore a database BAK to SQL Server 2008 Standard.  One object in the BAK file has compression and will not restore in this version of SQL Server, only the enterprise version.  So I need the capability of viewing the file and selecting what tables in the database I want to use or I need a way to restore the database without the compressed objects.
ASKER CERTIFIED SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
And two more:
3. Purchase a license for the SQL Developer Edition
4. Download and install the Enterprise Trial Edition.
Avatar of geek_vj
geek_vj

The best way is to use Enterprise Trial edition as suggested by acperkins as there is no need for you to pay anything. Once you get the required data, you can use your original edition again.