Archive for the ‘System administrators’ Category

SQL 2008 SA account locked out

Connect from the same server (via terminal), server administrators are by default granted access to SQL Server. Then issue:

ALTER LOGIN sa WITH PASSWORD = ‘new_password’ UNLOCK

Google Apps + Outlook: important notes

What is syncronized between Outlook and Google Server?

http://www.google.com/support/enterprise/static/gapps/art/users/en/glook/google_apps_sync_chart.pdf

If you have any information in your Outlook that is not syncronized to Google Apps Server, you should consider extra file-backups. TODO: which folders to backup?

How to clean Postfix queue from spam mails

If you have a lot of Postfix queue but there are some legitimate mails too, you can run the following command. This will remove mails going to a specific domain.

# mailq | tail -n +2 | head -n 100000 \
| grep -v "delivery temporarily suspended" \
| awk 'BEGIN { RS = "" } \
# $7=sender, $8=recipient1, $9=recipient2 \
{ if ($8 ~ /yahoo.com.tw/) \
print $1 } ' \
| tr -d ’*!’ | postsuper -d -

The command above only parses the first 100 000 rows of your queue. This is for giving you fast response if your search criterias gave any result.

To run search the whole queue, remove ”| head -n 100000″.

Return top