MSSQL backup restore method on MSSQL management studio

Following is the one of the Backup restore method on MSSQL server

Open Microsoft SQL Server Management Studio and login with admin privileges.

Expand database server name -- > databases -- > Right click select New Database as shown below.










Then it will redirect to the new DB creating window as shown below window, new DB name at database name and click ok (here can see where data files will store under path column).

 

The new DB will add to the list of databases as shown below.

To restore the backup file Right click on test (new ) database à Tasks à Restore à Database, as shown below

Then it will redirect to restore database-test window as shown below.

       1.Database name

 2. Select From device (need to be chose from where you are going table the backup file)

 3.  By click on browser button select database backup file.

 4.  Then it will add to select the database backup sets to restore section and check the box as show below.

 5.  The click on options.

Then below window will appear

6.       Check the BOX Overwrite the existing database

7.       Select the test database “mdf” file path, By Right clicking on DBàppropertiesàfileàright side plan UNDER database files section under path column “mdf” file can find(or while creating new DB under path column “mdf” file path can be find as above screen in this post)

8.        Select the test database “ldf” file path, By Right clicking on DBàppropertiesàfileàright side plan UNDER database files section under path column ”ldf” file can find(or while creating new DB under path column “ldf” file path can be find as above screen in this post)

        9.   Select recovery state as Leave database ready to use by rolling back uncommitted transaction.

10.       Then click on Ok, then restoring process will start, once restoring complete the completed successfully window will appear click on OK.