• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2128
  • Last Modified:

Import .bak file to SQL Server

How to import .bak file into SQL Server
0
rajgk
Asked:
rajgk
1 Solution
 
danblakeCommented:
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 ?
0
 
Dishan FernandoSoftware Engineer / DBACommented:
Hi rajgk,

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

Cheers!
DishanF.
0
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.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now