This is very basic topic in Microsoft SQL Server but still very important in developing , I hope this will helpful for you.
As
per this document environment is Microsoft SQL Server 2008.
Backup Database :
To create backup of database select any active database follow the steps which mentioned below :
Step 1: Select below menu options.
Step 2: Select folder directory where you want to store your backup.
Step 3: Here you have to Enter file name and if you are adding with extension .bak , it will solve your pre-bugs, for best practice use with name with extension.
------------------------------------------------------------------------------------------
Here you are able to see file path .
Step 4: After the completion of previous every steps Click on OK . and Execution process will start you can see the status in percentage , it will take time as per database size.
Step 5: In last , after successful - able to see one prompt dialog box , click on OK and you can do changes or updation with your selected database with safely backup.
Method 1:
Step 1: Create
New Database
Step 2: Insert Database meaningful Name and next click
on OK.
Step 3 : GO to Query
Explorer , which given Name Previously Click on as suggested down below :
Step 4 : Choose
Backup File from your Device directory via clicking on ADD button .
Step 5 : You are able
to see now Backup file with Extension .bak click on next to finish this
process.
-----------------------------------------------------------------------------------------
Step 6 : In a next ,
Click on General Tab and Enable – Check mark to selected database for further
restore process.
Step 7 : Cross
Verified End of the path of database ,
and you have to click must on Overview the existing database (WITH REPLACE)
Step 8 :Last you are
able to see executing process in percentage.
Step 9 : It will take
time as per database size be patient and wait until the finish process after
100 % execution , click on OK and now you are able to see in database directory
with every table hierarchy.
After the successful you can continue the next step with your developing Environment.
-----------------------------------------------------------------------------------------------
Method 2 :
In Case , if you are getting error while doing above steps to restore database , you can proceed with written Query .
After written the above query execute, and make sure you select a MASTER - Database only to
perform this action.
Now you are able to see the Successful Notification and hierarchy of tables in database.