ms sql question

Customer Support H-Sphere Reseller Hosting
1

hello,

  1. in regards to the recent post about sql hack: whats the best way to secure it ? (i have 2 huge ecomm clients - dont want people to mess around there)

  2. when the allowed space for transaction logs get filled up what would happen ? will it overwrite the existing log data or just give me an error ?

thanks !
Aleks

2

As far as the hack, it was more a forum hack than MSSQL hack, so insure you have secure passwords, and you are fine.

As far as the logs, we have the logging set to simple, but sometimes the logs wil still fill up, you need to use enterprise manager and execute a shrinkdatabase command.

3

thanks for clearing the hack thing.

On a 8mb sql db i had a transaction log file grown from 2mb to 14mb in one day … the shrinking of the database is not reducing the size that much. i dont mind the log file to grow - the question is : will the websites go down when its filled up ?

i had those sites on a dedicated server before so the size was not an issue .. when i moved each log file was around 25 GB in size :slight_smile: …

Thank you !

Aleks

4

Yes the website will go down if the log fills up, I will verify for sur eoyu are on simple logging if you can send me the servername, and database name in a private message.