Restoring .dat data to MSSQL

This is just a document in case I forgot to restore data files to MSSQL. I had this problem before when a colleague gave me a .dat files to be restored to SQL server. I had a 2008 version of the server and had no trouble restoring it. The problem is, I forgot how I did it when I had a new PC and I upgraded it to 2012 SQL server.

But this is a simple task (although I had a full day remembering how I did it and I had no luck finding the solution from google). First off, click restore, like so

I had trouble with the database whether or not to add a new database and restore the file to it, or not. Simple answer is no need. With the next image you can see that the configuration is very simple.

Just set it to device as the source and find the .mdf file. It automatically displays a suggestion for the database name and you're done. Click OK and wait a couple of minutes for SQL server to restore the data.

[EDIT] In case you are restoring a backup file without an extension. You can do so by setting the file name All files (*) when searching for the backup data.

Comments

Windows 10 HP Netbook Sucks, Lubuntufies it, Great!

I purchased a small netbook from HP few years back and it was installed with Windows 10 Home Edition. I tried it at the shop and works fine until I arrived at home and installed office suites, and some basic programming tools like Chrome, Python, Visual Studio Code that it became useless. Now it lags and my daughter can't even work with office suites. It was for her, it was a gift, it's suppose to work and not bother her. And now it becomes a pain for her doing research and Google Chrome always says "Not Responding". I just remembered it was 2 years ago. The netbook was just kept at the closet, intended never to see the light again. I was cleaning my small office at home and I found it, I remembered the pain. I remembered it all like yesterday. It was horrible, I cried and asked God, why did I remember all those miseries. Seriously, I just found it, that's it, and just thought, well I think I can have a use for it for a small server at home. Then it hits me, it...

Add Brave Browser to Netbeans

We'll I'm liking Brave now, great isn't it. With the token and all and privacy and stuff. And all the good stuff, right? So what other good thing we can do about it other than adding it to our favorite editor. So here it is, adding it is through Tools->Options->General Edit Web Browser Manager and add this setting below. Find the brave.exe usually it can be found in C:\Program Files (x86)\BraveSoftware\Brave-Browser\Application\brave.exe and voila we're good. See you next posts everyone!

nebulom

Search This Blog