problem restore databaze

Results 1 to 19 of 19
  1. #1
    Account Upgraded | Title Enabled! budhabils is offline
    MemberRank
    Jul 2008 Join Date
    Ho Chi Minh VNLocation
    245Posts

    information problem restore databaze

    i got error when i make ran server database bak file... im using windows7
    i already delete all rangame1,ranshop,ranlog,and ranuser and make fresh database ...
    i try to restore ep8 databse from crimz database and i connot restore it i got error
    see the attachment below
    Attached Thumbnails Attached Thumbnails bak.jpg  


  2. #2
    Listed Ervs is offline
    MemberRank
    Jul 2011 Join Date
    /root/Location
    947Posts

    Re: problem restore databaze

    Options > overwrite

  3. #3
    Account Upgraded | Title Enabled! budhabils is offline
    MemberRank
    Jul 2008 Join Date
    Ho Chi Minh VNLocation
    245Posts

    Re: problem restore databaze

    Quote Originally Posted by Ervs View Post
    Options > overwrite
    first
    right click rangame1 > task > restore > then add rangame1.bak file after i okay i connot event get to option
    because after i choose the add bak file the error pop up so i cannot got into option to overwrite it..
    any more idea?

  4. #4
    Listed Ervs is offline
    MemberRank
    Jul 2011 Join Date
    /root/Location
    947Posts

    Re: problem restore databaze

    Okay try this. Task > restore > add db > check the database below > options > overwrite > restore ok

  5. #5
    Listed Ervs is offline
    MemberRank
    Jul 2011 Join Date
    /root/Location
    947Posts

    Re: problem restore databaze

    You need to select the database first in able to go to option, try it if not work just post :)

  6. #6
    Account Upgraded | Title Enabled! budhabils is offline
    MemberRank
    Jul 2008 Join Date
    Ho Chi Minh VNLocation
    245Posts

    sad Re: problem restore databaze

    Quote Originally Posted by Ervs View Post
    You need to select the database first in able to go to option, try it if not work just post :)
    its me again Ervs still no luck because when i try this a i cannot even reach to check box see the attachment below
    Attached Thumbnails Attached Thumbnails 1.jpg   2.jpg   bak.jpg  

  7. #7
    Listed Ervs is offline
    MemberRank
    Jul 2011 Join Date
    /root/Location
    947Posts

    Re: problem restore databaze

    Oh i see! Good point, try to change your database and make sure you are using sql server 2008+ , as far as i know latest databases now are not compatible with sql2005 hehe

  8. #8
    Account Upgraded | Title Enabled! budhabils is offline
    MemberRank
    Jul 2008 Join Date
    Ho Chi Minh VNLocation
    245Posts

    Re: problem restore databaze

    Quote Originally Posted by Ervs View Post
    Oh i see! Good point, try to change your database and make sure you are using sql server 2008+ , as far as i know latest databases now are not compatible with sql2005 hehe
    ahhh okay ^_^ maybe can u give me the best link for sql for windows 7 ultimate?
    bcause in microsoft there are to many option to download i dont know 1 is i need to make ran private server...
    i think only 2 sql i need to install right can u give me this to link i will download it...
    very thanks in advance....

  9. #9
    Listed Ervs is offline
    MemberRank
    Jul 2011 Join Date
    /root/Location
    947Posts

    Re: problem restore databaze

    No, now you will just need to install one. And its already have management tools.

    Search for SQL Server 2008 r2 with tools :) then select your platform x86 or x64, cant give fast links now. Using only mobile

  10. #10
    Account Upgraded | Title Enabled! budhabils is offline
    MemberRank
    Jul 2008 Join Date
    Ho Chi Minh VNLocation
    245Posts

    Re: problem restore databaze

    Quote Originally Posted by Ervs View Post
    No, now you will just need to install one. And its already have management tools.

    Search for SQL Server 2008 r2 with tools :) then select your platform x86 or x64, cant give fast links now. Using only mobile
    thanks ^_^
    sorry for the inconvenient
    when i try to restore using ep6 bak files i t works...
    only in ep 8 T_T

    now i downloading the one u said that i need to install do i need to uninstall my previous sql management?

  11. #11
    Listed Ervs is offline
    MemberRank
    Jul 2011 Join Date
    /root/Location
    947Posts

    Re: problem restore databaze

    Yes you can restore db using 2005 up to 2k6 hmm. Try to change ur sql server gonna bit longer than you thought when you install it. But will solve your probs. If still now, then change your database to a new compatible db for your server then try again. Trial and error will help too :) goodluck

  12. #12
    Account Upgraded | Title Enabled! budhabils is offline
    MemberRank
    Jul 2008 Join Date
    Ho Chi Minh VNLocation
    245Posts

    Re: problem restore databaze

    Quote Originally Posted by Ervs View Post
    Yes you can restore db using 2005 up to 2k6 hmm. Try to change ur sql server gonna bit longer than you thought when you install it. But will solve your probs. If still now, then change your database to a new compatible db for your server then try again. Trial and error will help too :) goodluck
    \
    okay sir i will try it..
    now downloading
    ill be back with you later after i install it ^_^ thanks again already press like button for you Ervs

  13. #13
    Account Upgraded | Title Enabled! CodeXfire is offline
    MemberRank
    Mar 2012 Join Date
    Locating....Location
    313Posts

    Re: problem restore databaze

    sql2008 r2

  14. #14
    Account Upgraded | Title Enabled! budhabils is offline
    MemberRank
    Jul 2008 Join Date
    Ho Chi Minh VNLocation
    245Posts

    Re: problem restore databaze

    Quote Originally Posted by CodeXfire View Post
    sql2008 r2
    STILL CONFUSE WHAT TO DOWNLOAD FOR MY WINDOWS 7 64BIT

    SQL 2008 R2 >>>> THIS IS SQL EXPRESS RIGHT?
    AND WHAT TO DOWNLOAD FOR SQL MANAGEMENT? OR ONLY INSTALL SQL2008 R2 ARE INCLUDE OF SQL MANAGEMENT?

    I ALREADY UNINSTALL ALL MY OLD SQL SERVER EXPRESS AND SQL MANAGEMENT 2005..

    NOW I FINSIH DOWNLOAD SQL 2008 R2..
    AND WHAT IS THE NEXT RO DOWNLOAD AND INSTALL?
    ANY SUGGESTION ?
    THANKS IN ADVANCE SIR CodeXfire already click like button for you

  15. #15
    Listed Ervs is offline
    MemberRank
    Jul 2011 Join Date
    /root/Location
    947Posts

    Re: problem restore databaze

    Here buddy!
    SQL Server 2008 r2

    - select what platfom u using there, if you are 32bit then select SQLEXPRAWT_x86_ENU.exe, vice versa you will see that x86 for 32bit is 300mb+ only so its just a few seconds away to finish

    anyways regarding your SQL 2005, uninstall it all. SQL 2005 and the management studio. because 2008 2 will install a new one so better uninstall it to avoid conflicts and installing again probs :)
    installation might take a while.
    Last edited by Ervs; 16-08-14 at 06:38 AM. Reason: change adv to tools

  16. #16
    Account Upgraded | Title Enabled! budhabils is offline
    MemberRank
    Jul 2008 Join Date
    Ho Chi Minh VNLocation
    245Posts

    Re: problem restore databaze

    Quote Originally Posted by Ervs View Post
    Here buddy!
    SQL Server 2008 r2

    - select what platfom u using there, if you are 32bit then select SQLEXPRAWT_x86_ENU.exe, vice versa you will see that x86 for 32bit is 300mb+ only so its just a few seconds away to finish

    anyways regarding your SQL 2005, uninstall it all. SQL 2005 and the management studio. because 2008 2 will install a new one so better uninstall it to avoid conflicts and installing again probs :)
    installation might take a while.
    thanks in advance for the convenient
    is this include the management?
    only one installing right?
    because in old making private server we need to install sql express server 2005 and install also sql management studio 2005 right?
    how about here at new server using windows 7 64bit? only this SQL SERVER 2008 R2?

    Sorry for being STUPID of me... coz i try to search here how to make server in windows 7 64bit but all was
    transfering to other guide... again i already press like button to thank you ^_^

  17. #17
    Listed Ervs is offline
    MemberRank
    Jul 2011 Join Date
    /root/Location
    947Posts

    Re: problem restore databaze

    Yes it is already loaded with management tools. So its an all in one installation and your back to the track

  18. #18
    Proficient Member joelhes2009 is offline
    MemberRank
    May 2011 Join Date
    DevLocation
    194Posts

    Re: problem restore databaze


  19. #19
    Account Upgraded | Title Enabled! budhabils is offline
    MemberRank
    Jul 2008 Join Date
    Ho Chi Minh VNLocation
    245Posts

    Re: problem restore databaze

    Quote Originally Posted by Ervs View Post
    Yes it is already loaded with management tools. So its an all in one installation and your back to the track
    thank You sir for the reply also to you joelhes2009

    i just reinstall my previous sql server 2005 and sql management 2005
    i just put the bak files in my drive D because every time i put the bak files in drive c in sql back u folder i got an
    error thats why i put the bak files in drive d... and boom no error at all ^_^ by the thanks again dev team ^_^ i already click like button for you
    two ^_^ problem solve ^_^



Advertisement