How To install java and set environment path

Step 1:

First go to download the java pack using this link.

http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html

Step 2:

Download the pack and right click to install, default path location is

"C:\Program Files\Java\jdk1.8.0_xx"

Step 3:

Now go to Advanced system settings in control panel and select advanced tab

Or

Select Windows key + break key and select advanced system setting in left side panel

                                   

Step 4:

Now select environment variables in advanced tab

                                    

Step 5:

Click new in local system variables and then type,

variable name : path

variable value : c:\Program Files\Java\jdk1.8.0_xx\bin;

                                   

Now click OK button and close the system variables.

Step 6:

Now you have to check "Javac" command in command prompt if u get messages without error now java is working fine.

  

                                    

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.