Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a .bkp file, how can I restore it to SQL Server?

I have SQL Server 2008 and SQL Server 2012.

Any idea?

share|improve this question

closed as off-topic by Kin, Paul White, RolandoMySQLDBA, ypercube, marc_s Mar 12 at 19:39

This question appears to be off-topic. The users who voted to close gave these specific reasons:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Kin, marc_s
  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Paul White, RolandoMySQLDBA, ypercube
If this question can be reworded to fit the rules in the help center, please edit the question.

1  
RESTORE DATABASE –  DenisT Mar 12 at 14:22
    
let's google up this type doubts!!! –  Up_One Mar 12 at 15:58
    
Usually SQL Server backup files are .bak. Is the file actually a SQL Server backup, or is it from another source? –  Jon Seigel Mar 12 at 17:23

4 Answers 4

If it is a SQL Server backup file from a version earlier than 2008 or 2012 (or the same version, you can not restore a Sql Server 2012 backup file to a Sql Server 2008 instance) you can restore it to a new database by using the following command:

RESTORE DATABASE NewDBName FROM DISK = N'PathToBackupFile' WITH MOVE 'LogicalDataFileName' TO 'PathTo.mdf', MOVE 'LogicalLogFileName' TO 'PathTo.log', STATS=10

This will create a new database from the backup. If you want to restore to an existing database you would modify the restore command above to restore to the target database instead of a new database. You also may need to add REPLACE as well if you are restoring to an existing database.

Restore Database Command

share|improve this answer

You can find documentation on how to restore a database backup at http://technet.microsoft.com/en-us/library/ms177429.aspx

If you run into a problem, please edit your question adding the specifics of your problem.

share|improve this answer

SQL Server can only restore backups in its own format (mostly named .bak). bkp files could be from oracle or progress - you know best which product. You have to import the data manually into sql server after restoring it in the original program.

share|improve this answer

To use SQL Server Management Studio options:

  1. Right click Databases in Object Explorer
  2. Select Restore Database

enter image description here

3.Select Device and click ...

4.In the Select backup devices dialog, click Add

enter image description here

5.Make sure All files option is selected. By default, only bak and trn files are shown

enter image description here

6.Click OK and that's it

enter image description here

Note that you can restore a backup only if it has been created on the same SQl Server version, or earlier (but not SQL Server 2000 on 2012)

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.