Skip to main content

SQL Server Maintenance Plan

After changing your sa password, your maintenance plan might stop working and you might face a problem where you cannot delete the maintenance plan or edit. If you are facing such problem with your MS SQL server Maintenance Plan when you change your sa account password. Follow the following steps:

1. Select msdb database
2. Start a new query
3. select * from sysmaintplan_plans
4. Copy the id record and use it in the below query
5. delete from sysmaintplan_log where plan_id = ''
6. delete from sysmaintplan_subplans where plan_id = ''
7. delete from sysmaintplan_plans where id = ''
8. After you have run all the above delete sql query, check if the respective maintenance plan is available. normally, it wont be there, and even if there is delete it.
Labels:

Comments

Post a Comment

Popular posts from this blog

Clear Zimbra Mail Queue

If you want to clear mail queue from specific email address run the following command in your terminal. Below will remove mail queues, by checking FROM sender. eg. remove all mail queues sent by info@example.com /opt/zimbra/postfix/sbin/mailq | tail -n +2 | grep -v '^ *(' | awk 'BEGIN { RS = "" } { if ($7 == "info@example.comt") print $1 } ' | tr -d '*!' | xargs -rn1 /opt/zimbra/postfix/sbin/postsuper -d Below will remove mail queues, by checking TO sender. eg. remove all mail queues sent to info@example.com /opt/zimbra/postfix/sbin/mailq | tail -n +2 | grep -v '^ *(' | awk 'BEGIN { RS = "" } { if ($8 == "info@example.comt") print $1 } ' | tr -d '*!' | xargs -rn1 /opt/zimbra/postfix/sbin/postsuper -d
Post a Comment
Read more

Zimbra Mail Error: not enough free space in mail queue

If you are using Zimbra Mail and you are not able to send any mails and also you see an Error Message " not enough free space in mail queue " under /var/log/message. Then you should try out this solution. 1. Login to the server, and then again login as zimbra as follows: #su - zimbra 2. Check the Postfix message_size_limit, by default it should be 10MB (i.e. '10240000' bytes) as follows: $postconf message_size_limit message_size_limit = 10240000 3. If the value is higher than that, set it as follows to 10MB $ zmprov modifyConfig zimbraMtaMaxMessageSize 10240000 $ postfix reload Now try sending Mail, It should work. You could try out this solution for Error: " SMTP Server Reported: 452 4.3.1 Insufficient System Storage "
Post a Comment
Read more