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

asked on

Open SQL Server BAK file

How do I open SQL Server BAK file without using restore?  I only won't to view the script.
ASKER CERTIFIED SOLUTION
Avatar of Olaf Doschke
Olaf Doschke
Flag of Germany 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
This might help you find out more about the bak file you have at hand:

http://www.mssqltips.com/tip.asp?tip=1150

Bye, Olaf.
Avatar of geek_vj
geek_vj

>>How do I open SQL Server BAK file without using restore?  I only won't to view the script.
You cant open a bak file and read the data in it, however, you can view the logical and physical file names of it.
Please let us know what you meant by viewing the script so that we can suggest you better.
Avatar of jordanhelen

ASKER

I would like to see the code in the BAK file to determine what part of the restored database I want.
My problem.  I am using SQL Server 2008 Standard.  I have a backed up database that I need to restore.  It won't restore because one table in in the BAK file (database) has table compression.  So I need to be able to restore eliminating this table or open the file, look at it and determine what I want.
Can you help?
>>So I need to be able to restore eliminating this table or open the file, look at it and determine what I want.
Unfortunately this is possible only to a limited extent by using piecemeal restore - ie to restore the database based on filegroups. Here is some information about the same: (Do read under 'Piecemeal Restore Under the Full Recovery Model')

http://msdn.microsoft.com/en-us/library/ms177425(v=SQL.90).aspx

Pls revert in case you have any queries