Posts

Showing posts from July, 2014

How to Backup Database in SQL Server

Image
Step 1: Open SQL server management studio and right click on database.         tasks -----> Backup Step 2: In this window give a path where it is saved in your PC Step 3:  Click OK Step 4: Default it is saved in C Drive

How to restore Data Base in SQL Server

Image
Step 1: Open SQL server management studio and right click on database and select Restore Database  Step 2: Give a name which database is restore in To Database Step 3: Browse a restore database file where it is located in your PC Step 4: Click on Dialog box and click OK Step 5: Go to SQL server management studio and view a restore database Step 6: Same process follow a bellow steps