Solved

Restore or open SQL Server 2008 BAK file.

Posted on 2011-02-13
3
494 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

929 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

14 Experts available now in Live!

Get 1:1 Help Now