CODEWITHSUNDEEP
sqlsql-serverdatabaset-sql
Haikal Nashuha
Haikal Nashuha

Reputation: 3048

How to setup database in SQL Server by an unknown file?

Probably this is the lamest question ><

I am developing an ASP.net web app with SQL Server database. When the client asked me to develop the system, he provided a file for the database.

I thought the file was a dumpfile (if you familiar with oracle or mysql, you can replicate database with dumpfile, which is basically bunch of queries inside a text file).

To my horror, plus with my noobity in SQL Server, I found out that it was NOT a dumpfile. The file is rename to .bak which is not really the correct extension for SQL Server. I tried to rename it to .mdf, but no luck.

What should I do? The client is out for vacation on some island and cannot be contacted at the moment?

Upvotes: 2

Views: 244

Answers (3)

Morten
Morten

Reputation: 3844

Alex Aza has the right answer. But remember to create users for the database, before you restore the provided .bak file. A backup file only hold a user id -- the complete user definition is held in the server instance. Thus, it is better to create the users needed before restoring a backup from another server instance which is the case in your project.

Upvotes: 0

Alireza Maddah
Alireza Maddah

Reputation: 5885

This is SQL Server backup database file. You can restore it by following these steps: http://msdn.microsoft.com/en-us/library/ms177429.aspx

Upvotes: 1

Alex Aza
Alex Aza

Reputation: 78447

This is backup file, you need to restore database from backup.

How to: Restore a Database Backup (SQL Server Management Studio)

Upvotes: 3

Related Questions