Solved

Restore or open SQL Server 2008 BAK file.

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
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 …

861 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