Question : I just installed SQL server 2016 (Standard edition) on a new server, I’m trying to add a Maintenance […]
Tag: maintenance-plans
Can I pass data between stages in a maintenance task
Question : I have a Maintenance plan that I wish to execute nightly. The purpose is to set an archived […]
Backup of Databases not present in Availability Groups
Question : How can I take backups of databases that are not present in Availability Groups? Can I use a […]
Can I export a maintenance plan without using Integration Services?
Question : I’m trying to export a simple maintenance plan from an SQL Server instance. I want to check the […]
What are possible backup command origination sources?
Question : In the backupset table I can see couple of backups that I am unable to understand where they […]
Backup Database Task – What’s the number at the end of the filename?
Question : When using a SQL Server 2012 EMaintenance Plan for backup purposes, the Backup Database Task creates a unique […]
SQL Server maintenance plan not working after renaming administrator
Question : I have renamed the Windows administrator account to TEST using Local Group Policy editor. After that, the SQL […]
Very high I/O on database during a backup maintenance plan
Question : I’ve recently been having some hellacious problems with a specific maintenance plan. I found that part of the […]
SQL Server backup practice with limited disk space
Question : I have a SQL Server 2012 Std Edition installed, contain 1 database in full recovery mode, so the […]
How do I view operators in a Notify Operator task in a Maintenance Plan?
Question : In the past, we have added each DBA to a Notify Operator task on failure in Maintenance Plans […]