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:
A place to find insight into SQL
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:
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.