Environment: SQL 2005
Symptom: Scheduled SQL maintenance plan to do partial backup failed. Got two message logged in SQL Server log:
Error: 3041, Severity: 16, State: 1
BACKUP failed to complete the command BACKUP DATABASE master WITH DIFFERENTIAL. Check the backup application log for detailed messages.
Cause: Master database does not support partial backup. So, if the task is for "Differential" backup, "master" database should not be included.
Solution: Open the plan details, in the "Database(s)" section make sure database that needs to be backup are explicitly selected, instead of having "All databases" checked.
Tips that make life of a software engineer easier. Well, not exactly. Some posts are open questions that I haven't found an answer ... yet
Monday, August 08, 2011
Monday, August 01, 2011
Coldfusion Webservice Input Name Changed to in0
Symptom: Coldfusion webservices sometimes complain about input parameter "In0"
Environment: Coldfusion 9 on Windows
Solution: Login to Coldfuion 9 Administrator portal, Go to Server Settings > Caching, click on "Clear Template Cache Now" and "Clear Component Cache Now". This seems to trigger to re-compile of webservices WSDL thus fixed the problem.
However:
Environment: Coldfusion 9 on Windows
Solution: Login to Coldfuion 9 Administrator portal, Go to Server Settings > Caching, click on "Clear Template Cache Now" and "Clear Component Cache Now". This seems to trigger to re-compile of webservices WSDL thus fixed the problem.
However:
- I don't know what is the root cause of this problem. Google turn-up some similar complains, but could not find any official answers on this
- The solution which required human interaction does not help in production environment
- The solution does not solve the problem permanently, sooner or later I'll hit the same error, and has to go back to the server and clear cache again
Subscribe to:
Posts (Atom)