Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


How can I open a file with .BAC extension?

Posted on 2011-10-31
Medium Priority
Last Modified: 2012-08-13
How can I open a file with .BAC extension? This file is an SQL backup. Any help appreciated.
Question by:RudiOrkisz
LVL 25

Accepted Solution

Lee Savidge earned 2000 total points
ID: 37056984
Rename it to a .bak and then go into SQL Management Studio and restore the database. If you want to restore it as a new database, create a new empty one first and then restore into it. Ensure that you choose the correct paths for the database as you're restoring it.

Expert Comment

ID: 37058075
Generally backup files are used to restore the database.
So try to restore it in any one database that you want.

Author Closing Comment

ID: 37064123
Only my thanks.

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

There are some very powerful Dynamic Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a di…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

581 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