Import .bak file to a database in SQL server

sql-server database-restore
Tibin picture Tibin · Oct 8, 2009 · Viewed 397k times · Source

I have a file with .bak extension.

How can I import this date to a database in SQL Server?

Answer

Marcelo Mason picture Marcelo Mason · May 20, 2015

On SQL Server Management Studio

  1. Right click Databases on left pane (Object Explorer)
  2. Click Restore Database...
  3. Choose Device, click ..., and add your .bak file
  4. Click OK, then OK again

Done.

Related questions

SQL Server database restore error: specified cast is not valid. (SqlManagerUI)

I am using SQL Server 2008 R2 Standard (version 10.50.1600.1) for my production website and SQL Server Express edition with Advanced Services (v10.50.1600.1) for my localhost as a database. Few days back my SQL Server crashed and I had to install a …

Read More
How to import a bak file into SQL Server Express

I have a .bak file, and I want to use this file to recreate the database in a fresh install of SQL Server 2008 Management Studio. Can someone point me in the right direction on how this can be done? I …

Read More
Create/restore database from backup SQL Server Express

I don't have SQL Server Management Studio on my machine. I have a database backup (SQL Server 2008 R2). There is SQL Server Express that installed with Visual studio 2010 ultimate installed on my machine. How can I restore this back up …

Read More