[Tut]Fixing SQL Restoring Database error

Results 1 to 4 of 4
  1. #1
    Valued Member lil_Homie is offline
    MemberRank
    May 2010 Join Date
    134Posts

    [Tut]Fixing SQL Restoring Database error

    Do you ever get a error like this?

    Then you go like OMFG WTF BBQ NOT EVEN THIS BACKED UP DB IS WORKING D;!

    well, This tut is to help you fix this error? I wasted 30mins pressing the same button then I decided to try something else and guess wut? "The GunzDB has been restored Successfully"!

    So here are the Steps to fix this error:

    1. Place your db/Backup db in the following directory:
    C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup
    2.Start up SQL Express
    3.Right click GunzDB>tasks>Backup
    4.Go select your db in the directory I told you to put in
    5.Click OK (Duh)
    6.Now go to GunzDB>tasks>restore
    7.Instead of using the from file option, Use the from Database option
    8. Now your DB should show up so go to options>Overwrite DB
    9. Press OK
    10. DONE! YOUR DB HAS BEEN SUCCESSFULLY RESTORED

    This is my first tut for anything and I kinda wrote this off of my head so I might be missing one or tiny things but it should work anyhow o.o!

    -->Don't forget to press thanks if I helped<--

    ~Homie
    Last edited by lil_Homie; 28-08-10 at 04:35 AM.


  2. #2
    Account Upgraded | Title Enabled! RodiSR is offline
    MemberRank
    Oct 2009 Join Date
    313Posts

    Re: [Tut]Fixing SQL Restoring Database error

    Actually you can backup your db at any places just go to ..
    SQL server configurations -> SQL SERVER -> Right click -> Change network server to localhost.
    apply, Restart SQL server and done.

  3. #3
    Valued Member lil_Homie is offline
    MemberRank
    May 2010 Join Date
    134Posts

    Re: [Tut]Fixing SQL Restoring Database error

    This is a way I found out myself. So I just liked to share it sheesh o.o!

  4. #4
    num num num <3 rootbeer daniel131605 is offline
    MemberRank
    Jul 2008 Join Date
    New YorkLocation
    573Posts

    Re: [Tut]Fixing SQL Restoring Database error

    useful i guess :P



Advertisement