SQL

Microsoft potshot: Oracle raising it’s pricing structure

Take a look:

 http://www.theregister.co.uk/2009/07/27/…

So Microsoft reminds us that SQL server is still available at the same cost while Oracle is raising it’s prices. Now if only SQL server was any good …. they might just have something there.

SQL server not deleting files as part of Database Maintenance Plan

I have actually seen this issue now twice in a two week span at different clients with the same resolution so either it’s a common issue or it’s just a coincidence. In this scenario the database maintenance plan is set to delete old backup jobs, the job completes but the files are not deleted. In both cases the fix was simple, in the plan it asks you to specify the file extention it should delete which in most cases is bak. Make sure when you are entering this yyou enter JUST bak, not .bak or “bak” or anything else. If you have any charachters (including spaces) other than just the letters bak it will not work.

Hope this helps you

SQL backup jobs failing

 I don’t work with SQL jobs too much, but here is an error I just got, but I was troubleshooting an issue with SQL backup jobs failing, here was the error in event log.

tcpsvcs (2640) The backup has been stopped because it was halted by the client or the connection with the client failed.
Though the SQL server agent looked fine, I stopped ans started it anyways and that fixed the issue.