Search this blog

Home Download Tips Our Stores About

Adbrite

Your Ad Here

Hot Offers


Masukkan Code ini K1-2BE745-X
untuk berbelanja di KutuKutuBuku.com

Visit Our Sponsor

Wednesday, May 27, 2009

How to Restore SQL Server Database File  

First of all. Open SQL Management Studio. And get connected.
Then you'll see the There's many menus in the left side.
Photobucket




Then. Right Click in the "Databases"
Choose "Restore Database" then this will appear

Photobucket

And this will appear
Photobucket

In the "To Database" field type whatever the name of your database
And Choose "From Device" Radio Button and click the ... button

Then it'll open like this...
Photobucket
Browse to your Database which you want to restore.. And Click OK and OK

Then...
Photobucket
Check the Checkbox. And Click OK... Wait until it executing 100%.
DONE...

If there's an error messages like this
Photobucket
Click OK..

Then.. Navigate to the left side and choose "Options"
Photobucket
Check the First Object "Overwrite the Existing Database"
Click OK and DONE...

Photobucket

Drop Comment below if there's something wrong...



What next?

You can also bookmark this post using your favorite bookmarking service:

Related Posts by Categories



1 comments: to “ How to Restore SQL Server Database File

  • sagar
    May 31, 2009 6:12 PM  

    Sometimes I respond to comments, but this year it really hasn't been very often, but I do try and go to their blog and comment on one of their posts. I very seldom check to see if anyone has responded to any comment I make.

    Please Read:
    Enter to my " 1st FUNNY CONTEST " held at my blog . Winners will get a free 120*120 Adspot on my Blog for a period of 1 Month. END DATE: 13 june 2009

    SEO Status of this blog:

    1) Google PR #2
    2) Alexa Ranking: 160,082
    3) Backlinks: 5000+
    4) Daily Unique Visits: 250 - 350
    5) Daily Pageviews: 1000+

Post a Comment

Best Seller