Solved

Restore or open SQL Server 2008 BAK file.

Posted on 2011-02-13
3
493 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:jordanhelen
  • 2
3 Comments
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 34883865
You have a couple of options.  
1. Upgrade to the Enterprise Edition.
2. Upgrade to SQL Server 2008 R2 Standard Edition.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 34883871
And two more:
3. Purchase a license for the SQL Developer Edition
4. Download and install the Enterprise Trial Edition.
0
 
LVL 13

Expert Comment

by:geek_vj
ID: 34885641
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.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This video discusses moving either the default database or any database to a new volume.

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now