Picture Guide for Restoring .bak DB to MS SQL 2005

We all know all video tutorial on YouTube have blocked by Min Communications, so I decide to make a picture guide so newbie understand easier even without a video tutorial, newbie can still follow the guide....

this guide are for those noob and newbie have no idea how to Restoring Database for MS SQL 2005 for any Episode...


1) First of all know where you can put your backup database, so I suggest put in on Drive C where you can easily find..
http://forum.ragezone.com/attachment...2&d=1341282277

2) Login to your Microsoft SQL Server Management
http://forum.ragezone.com/attachment...3&d=1341282285

3) Now go to the database and create new database
http://forum.ragezone.com/attachment...4&d=1341282291

4) Create a database name
http://forum.ragezone.com/attachment...5&d=1341282297

5) Now restoring the .bak database just follow the picture
http://forum.ragezone.com/attachment...6&d=1341282302

6) go from device
http://img220.imageshack.us/img220/7910/82478952.jpg

7) then click add
http://img717.imageshack.us/img717/3176/28985659.jpg

8) find the location of your .bak database see my sample
http://img708.imageshack.us/img708/7519/97784710.jpg

9) Then hit ok
http://img15.imageshack.us/img15/8831/59256466.jpg

10) the most common error newbie always encounter ...
http://img836.imageshack.us/img836/3216/69502942.jpg

11)
http://img845.imageshack.us/img845/9520/32915042.jpg

12) just use your brain ....
http://img99.imageshack.us/img99/8317/38962665.jpg

13) easiest way ....
http://img528.imageshack.us/img528/1/54317391.jpg

14) copy paste...
http://img853.imageshack.us/img853/7987/86100127.jpg

15) now you done
http://img651.imageshack.us/img651/5667/98780637.jpg

16)
http://img535.imageshack.us/img535/8205/22251177.jpg

17) just follow the step and you won't lost for the remaining .bak database...
http://img594.imageshack.us/img594/3728/87569681.jpg



I hope... it consider helpful for the beginner...



don't forget to hit liked for my effort...







...

thanks a lot !! super hit like


to some sharer please provide like this step by step . its more way easier

Attachment 108862

i got error, im following your guide but still thesame error.

@kenn14 its say on your ss that you have existing RanGame1 database,,, there are option.... first ether delete the existing one or reinstall you new mssql...

Attachment 116816



Anyone can fix this PROBLEM?

@kenn14 if you have an existing rangame1 do this..

Rightclick to Databases>RestoreDatabase then continue backing up your db

I don't have web.bak that's also need..?
anyone can give me a database with web.bak?

Quote:

---

Originally Posted by francis112

I don't have web.bak that's also need..?
anyone can give me a database with web.bak?

---

no need just rangame1 ranlog ranshop ran user

i also have the same error like francis112. i already reinstalled my MSSQL still i got the same error. please help us

you dont need that web.bak that is for dutch x pannel only

Attachment 117746

plss help me with this tnx for a reply :D

Attachment 117759

Can you help me about this? tnx....... :(:

like I say... you have existing RanGame1 database,,, there are option.... first ether delete the existing database on you program file or reinstall you new mssql...

ok i will tnx :D

wait theres more haha! :D how about ODBC i will make a new after reinstall again?

omg!! i cant re install my SQL T_T