MS SQL DB Restore

Discussion in 'Programming' started by CHWH-Admin, Mar 22, 2011.

  1. #1
    hi,

    I currently hosted in helm planel my Database in MS SQl2000 .

    now i take new server with pleask 9.5 panel

    how can i restore MSSQL2000 data to ms sql2005 DB

    And my website developer only give me IP adderes ,username and password for old database. i dont know how can i logon?
    Please help me

    Regards,
    Neal
     
    CHWH-Admin, Mar 22, 2011 IP
  2. AstarothSolutions

    AstarothSolutions Peon

    Messages:
    2,680
    Likes Received:
    77
    Best Answers:
    0
    Trophy Points:
    0
    #2
    It depends if the database allows remote connections or not. If it does then you can download MS SQL Studio Express (free) and connect to the db from your desktop. If it doesnt then you should be able to access it via a web solution via Helm
     
    AstarothSolutions, Mar 23, 2011 IP
  3. CHWH-Admin

    CHWH-Admin Active Member

    Messages:
    342
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    85
    #3
    I take this database separate.but in the same server provider not give me any administration the only give username & password.

    any access link for helm database managment?
     
    CHWH-Admin, Mar 23, 2011 IP
  4. AstarothSolutions

    AstarothSolutions Peon

    Messages:
    2,680
    Likes Received:
    77
    Best Answers:
    0
    Trophy Points:
    0
    #4
    I have only used Helm a few times and in each of those all you can do is add/ delete databases (simply databases.asp in the url) and add/ delete/ password change database users (database.asp?DomainID=#&DatabaseID=#).

    In each case the copy on database.asp has given you the URL of a different database management tool outside of Helm
     
    AstarothSolutions, Mar 23, 2011 IP