Solved

Restore or open SQL Server 2008 BAK file.

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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

770 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