How To Import or Restore MSSQL(.BAK) DB

MS SQL is short for Microsoft SQL Server. It is a relational web hosting database that is used to store web site information like blog posts or user information. MS SQL is the most popular type of database on Windows servers. It is not free but it has many advanced features that make it suitable for businesses.

Step 1:
Open the SQL studio management

                                   


















Step 2:
Enter your login credentials.

                                     

Step 3:
Select database option in your left panel then right click the database for create new database.

                                     

Step 4:
Enter a new database name for create DB. (eg: Database name is TEST) then Click next.

                                   

Step 5:
Now right click the test DB in left side panel then select task in sub menu and then select restore then click restore to database.

                                    

Step 6:
In windows, Select the radio button for restore the database from device and then click add button.

                                     

Step 7:
Select database for which database do u want to restore for test DB then click OK.(eg: test.bak)

                                     

Step 8:
Select check box restore in select backup sets to restore option.

                                     

Step 9:
Select the check box overwrite existing database and replication settings in restore options then click next.

                                     

Step 10:
DB restore process is sucessfully completed.