ms sql question

B

bakalek

Perch
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
 
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.
 
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 :) ...

Thank you !

Aleks
 
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.
 
You must log in or register to reply here.
Back
Top