SQL Server

Discussion in 'Database Support' started by rohan, Apr 29, 2003.

  1. rohan

    rohan Guppy

    I'm confused. The CP allows me to create a SQL database as well as create a DSN to a SQL database. What is the difference?
  2. Yash

    Yash Bass

    You can create one hosted MS SQL database with your package. You can also store SQL databases in your disk space and connect to them via DSN.
  3. Bliss

    Bliss Perch

    I have a question about this, as I am also confused. How do we DSN to our SQL databases if we host them on our storage space?
  4. Yash

    Yash Bass

    Yes, you can do that.
  5. Bliss

    Bliss Perch

    How do you move your database to your disk space?
  6. Yash

    Yash Bass

    You can store the database on your disk space and create a DSN from the CP specifying server address. I am not sure if this available for alll drivers. What type of database are you talking about?
  7. Bliss

    Bliss Perch

    I'm talking about a MsSql database. How do you get it to your storage space?
  8. Yash

    Yash Bass

    We plan to disable this feature very shortly as it is causing delayed responses on our server. This affects all the customers on that server.

    instead, what you can do is host the database on your computer.
  9. Bliss

    Bliss Perch

    Also, what does the log for MsSQL server do?
  10. Yash

    Yash Bass

    The log file just logs database activity. It is useful for security reasons. You may delete if you like
  11. Bliss

    Bliss Perch

    ?( How do you delete the log?
  12. Yash

    Yash Bass

    It depends. If your database is stored on your disk space, a log file should have been created next to it. If this is a hosted database, you can find all other log files in the "log" folder in your root directory. However, I wouldn't recommend deleting any log files till you are low on disk space.
  13. Bliss

    Bliss Perch

    I just ran out of space, and I went and deleted some of the logs, but on my status panel for the database, it still says I'm used a lot of my space left. Does it matter that the cp still did not change?
  14. Yash

    Yash Bass

    You only see a change in your Disk Usage meter if you deleted logs files over 1MB. If you have ran out of disk space, the best thing you should do is upgrade to the next package or buy some more megs
  15. Bliss

    Bliss Perch

    The problem is I only delete my logs when my quota is reached on my ms sql database, and I can't just keep buying database space! Perhaps I'm not deleting the right logs?
  16. Yash

    Yash Bass

    Oh, I thought you meant disk space. The DB log files are deleted routinely by our system administrators and don't count towards your total usage.

Share This Page

JodoHost - 26,000 hosting end-users in 100 countries
Plesk Web Hosting
VPS Hosting
H-Sphere Web Hosting
Other Services