Import .bak file to SQL Server

How to import .bak file into SQL Server
Who is Participating?
danblakeConnect With a Mentor Commented:
It is possible to restore a .bak file (if it is a sql-server backup file),
using restore database t-sql command (if it is a sql-server backup file).

The question is what file type is it, what is the format of the file ?

There are various bulk-load utilities to load in a file into sql-server, but do you have the file format ?

And what does the file represent ?
Dishan FernandoSoftware Engineer / DBACommented:
Hi rajgk,

Open Enterprise Manager.
Right Click on the Database > All Task > Restore Database..

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.