Backup Script to replace xp_sqlmaint

Need a backup script because xp_sqlMaint is not running on 2008? Try this one. You need only fill in the database name and directory name in the appropriate places below:

One Reply to “Backup Script to replace xp_sqlmaint”

  1. Thank you for posting this. Do you have any recommendations for other maintenance tasks that use xp_sqlMaint such as shrink, reindex, or ckdb? I have T-SQL that use xp_sqlmaint to manage multiple servers dynamically. I’ve been looking for replacement T-SQL so I can continue to use my scripts.

Leave a Reply

Your email address will not be published. Required fields are marked *