SQL SERVER DATABASE BACKUP AND RESTORE DATABASE

By -

While working with database we need to store our information time to time. and for that purpose we take the backup for that database. Backing up a database provide many solutions for us. The main thing is if we lost our database from SQL Server then we can restore our database from our computer. Also when we perform changes in our database the backup database automatically update the changes to the backup file. In this article we are going to create a backup file of Database. The backup file always contain the extension (.bak). Also we are going to learn how to restore the database later in the article.
Backup Database:
Step 1: Right click on the Database Name-> choose Tasks -> click on back up.
Step 2:  Click on Add button to create a database file.
Step 3:  Choose the Location where do you want to save your backup file.
Step 4:  After inserting a name of your backup file click on ok. You will get the following message box.
Restore Database:
Step 1:  Right click on Database -> select Restore Database.
Step 2: Choose the Radio button “From device”. then click on the button to get the database backup file.
Step 3:  Click on the ‘Add’ Button to get the database backup file.
Step 4:  Choose the database backup file that you want to restore.
Step 5:  After selecting you click on ‘Ok’ button. Then you need to check the ‘Restore’ button. Then click on ok.
Step 6:  You can see the following window.

Comments

Post a Comment

Popular posts from this blog

Smart Storage Tips for a Clutter Free Bedroom

By -
Image
The  bedroom  is the area in the house that is more personal and private. One spends most of his time inside the bedroom especially when much rest is needed. Hence, since it is a personal room, one’s belongings and important stuff including clothes, jewelries and others are also inside it. There would be a need to organize all the things inside the bedroom in order to make it clutter free. It is also necessary to do that so that you will not find it hard to look for your own stuff. There are many ways to create storage spaces in your bedroom. Choosing one depends on the type of room you have and it also depends on your storage needs. Today, we will give you some tips on how to create  smart storage space  in your bedroom to have a  clutter free room . Look into the tips below and choose which one best suits you. 1. Open storage. Image:  Vhychenq Try for open storage especially if your bedroom is only small. Place some items on it l...
Read more

29 Semi-Productive Things I Do Online When I’m Trying to Avoid Real Work

By -
You don’t always have to work hard to be productive.  Productivity can simply be the side effect of doing the right things. So here’s a list of 29 semi-productive things I do online when my mind is set on avoiding ‘real work.’ Check delicious popular tags like ‘ useful ,’ ‘ tutorials ,’ ‘ tips ,’ ‘howto ,’ ‘ advice ,’ ‘ entrepreneurship ,’ etc. for interesting, educational articles to read. Watch one of the thousands of educational videos streaming at TED.com , Academic Earth and Teacher Tube . Read an online book list and find a new book to grab next time I’m at the library.  Here’s another list .  And another .  And another . Read a classic book online for free at Project Gutenberg , Planet eBook , or the E-books Directory . Research a new Do It Yourself project at DIY Network , Instructables , eHow , or WikiHow . Add to, delete from, or just generally sort my ongoing to-do list at Remember The Milk . Create a cool graphical mind map of some of my recent ...
Read more

Top 5 Most Alcoholic Drinks (Cocktails)

By -
Image
5 Strongest Drinks Mixed Drink Recipes #5: The Long Island Ice Tea. This one is a classic. I can remember the first time a friend introduced me to this. After three I was laughing because they were so smooth then I stood up. Then something happened (obvious censoring) and everyone laughed at me for months after. Good times. The Long Island Ice Tea was long the king (queen?) of all strong alcoholic mixed drinks, and still deserves a place on the list. Recipe: 1 shot of vodka, 1 shot of rum, 1 shot of gin, 1 shot of gin, 1 shot of triple sec, 1 lemon, coke. Fill a cocktail shaker with ice add the spirits into the cocktail shaker. Squeeze a fresh lemon into the shaker as well. Put the lid on and shake, add to a tall glass then add lots of ice before slowly pouring the coke on top of the ice. Note: many bartenders will make a weaker version with only half a shot of each. #4: Irish Car Bomb. Many versions of this have a ½ shot of whiskey mixed with a ½ shot of Irish Crea...
Read more