- I'm using ms sql and then i export the database and then i save that export DB at desktop.After that i delete the database in ms sql because i want to learn how to import the DB.My problem is cannot import the DB that i export before.Anyone can help me to give the tutorial how to import the DB into MS SQL.

- This is the file of DB that i want to import into ms sql :


Recommended Answers

All 2 Replies

What exactly is the problem, that you are facing ?

The file you saved is a SQL backup. You have to RESTORE to get it into SQL Server. You can either do this through the Management Studio GUI or using a RESTORE DATABASE command (look in BOL for syntax).

Keep in mind that the Management Studio GUI expects the file to have a .BAK extension, so be sure to use the drop-down to select "All Files (*.*)" so you can see your backup file.

Good luck!

Edit: I hope none of that data was sensitive, proprietary or confidential...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.