Browse by Tags

SQL Server - database maintenance gotchas

Published 3 December 7 12:43 PM | SSQA.net

What kind of database maintenance operations you should be doing when you are DBA? You should have better understanding on the terms in managing the Database platform at your end, without proper information it is very hard to say you are managing your...

Filed under: dashboard, sql server, performance, databases, security, maintenance plan

TSQL script for deleting backups older than 1 day

Published 10 September 7 4:34 AM | SSQA.net

Common question and ranting about Database maintenance plans in the forums, in this case I always suggest to use another job using TSQL to drop those older backup files. Andrew Kelly, SQL MVP has contributed an excellent script sample that should get...

Filed under: sql server, databases, backup, maintenance plan, drop, tsql, forced, older