How to use two SQL DB when one is not big enough?

Discussion in 'C#' started by JJnacy, May 28, 2009.

0
  1. #1
    I have two DB each one is 200 MB.
    A-DB is using and B-DB is not using.
    What shall I do when A-DB is full?

    Thanks/Regards
     
    JJnacy, May 28, 2009 IP
  2. Social.Network

    Social.Network Member

    Messages:
    517
    Likes Received:
    15
    Best Answers:
    0
    Trophy Points:
    35
    #2
    I am going to make an assumption here. The databases are hosted, correct? You can use the other database, but it would be easier to pay the host for additional disk space. If you insist on using the other database in parallel, let me know.
     
    Social.Network, May 29, 2009 IP
    JJnacy likes this.
  3. alexsurge45

    alexsurge45 Guest

    Messages:
    60
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    yes you can use two databases in parallel.Just create multiple database handles and connect each one to a different database.
    And i do agree with social networking, if you are hosting then u can buy additional disk space.
     
    alexsurge45, May 29, 2009 IP
    JJnacy likes this.
  4. yugolancer

    yugolancer Well-Known Member

    Messages:
    320
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    110
    #4
    I would assume further and say that most probably you use one of the GoDaddy's shared hosting plans.
    Maybe Delux ? lol

    However in your case it is best to consider buying of dedicated server or at least virtual one.
     
    yugolancer, May 30, 2009 IP
  5. JEP_Dude

    JEP_Dude Peon

    Messages:
    121
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Hey there!

    I'm slightly past the ASP.Net Newbie stage. So, please excuse me for asking this question.

    What is the difference between a "dedicated server" and a "virtual one"?

    May you have a blessed day as the LORD wills.
     
    JEP_Dude, Jun 4, 2009 IP
  6. yugolancer

    yugolancer Well-Known Member

    Messages:
    320
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    110
    #6
    virtual dedicated (not only virtual) server is sort of semi-private server and you share the resources cpu and ram with a few others usually with only one. Means unlike dedicated server where the resources are all yours here you need to share them with someone
     
    yugolancer, Jun 7, 2009 IP