Questions tagged [maintenance-plans]
Workflows created through SQL Server Management Studio that help automate SQL Server maintenance tasks like backups, index rebuilds, and updating statistics.
116
questions
0
votes
2answers
524 views
T-SQL Statement Task choose specific database name on server
I try to create a simple T-SQL Statement Task by Sql Server 2014 GUI.
My flow:
Right click on Maintenance Plan
Choose Create new Maintenance Plan
Choose the type (T-SQL Statement Task)
I add by ...
0
votes
1answer
126 views
Will an hourly T-Log backup in a Maintenance plan write a file if there are no changes to a DB?
I have an hourly maintenance plan the runs a T-Log backup. Some of my databases may have every hour represented in the file system, while others have some hours "missing" or even none at all. Is it ...
0
votes
1answer
744 views
How to know that , Is it Maintenance Cleanup Task is working properly from maintenance Plan or not through T-SQL?
I would like to say that i had configured "Automatic DB Backup" as well as "Automatic DB Cleanup Task" through "Maintenance Plan" in MS SQL Server 2012 on my Production Database. And that is working ...
0
votes
1answer
11 views
Assigned filetype for backups not applying
I am working to migrate backups over to a new storage point. I figured the easiest thing to do was to duplicate the configuration over from the existing Maintenance Plan to a new one, just in case ...
0
votes
0answers
133 views
Unable to Create new Maintenance plan in SSMS 2017
Hi I have reinstalled SQL Server 2016 in my database server last day.
I am able to connect to SQL Instance(SQL-02) using the SSMS 2017 i had earlier in the same server before reinstall.
But when i ...
0
votes
1answer
37 views
Unable to create maintenance plan
When trying to create a maintenance plan locally on two prod servers through SSMS, I receive this error:
No such error occurs on my UAT system. They're all running SQL Server 2017 (14.0.3162.1), and ...
0
votes
0answers
38 views
CheckDB Failure on most databases in Dev instance
I have a maintenance plan on one of our infrequently used dev boxes which keeps failing on CheckDB on all user databases and most system databases. When trying to run CheckDB manually, I get the ...
0
votes
1answer
21 views
Maintenance Plan Wizard generates invalid date parameter in script for delete
The generated SQL for my Maintenance Plan is
EXECUTE master.dbo.xp_delete_file 0,N'''',N'''',N''2019-01-02T10:44:21''
but the execution returns error message
Msg 102, Level 15, State 1, Line 1 ...
0
votes
0answers
32 views
Maintenance plan changing from ALL USER DBs to SELECT DBs automatically
We came across an odd bug in Maintenance Plans on SSMS 2016 and 2017 for SQL Server versions 2012 and 2016 (at least). The setup is unusual, but I couldn't find anything about this or any similar ...
0
votes
0answers
309 views
Reorganize index maintenance job is more than 20 times slower
I have a reorganize maintenance job which runs daily (I know, this have been altered to weekly) which for the majority of executions it takes around 2 hours however over the weekend has failed with ...
0
votes
1answer
46 views
How can I share values in maintenance plan tasks?
A simple example would be a maintenance plan that clears a directory of old files and create some copy backups of all databases on that instance to that same directory. This is run daily
The first ...
0
votes
1answer
58 views
How can I automate the process of checking of column and executing SQL statement?
I am experiencing quite difficult problem and hope for your feedback. In my table I have a "Services"column in "MyData" table which contains names of my services. I have created SQL statement which ...
0
votes
1answer
142 views
Text file report is not generating of Availability Databases other Databases during auto backup through maintenance plans in MS SQL Server 2012
I have setup Automated backup in SQL Server 2012 Enterprise Database backup through 'Maintenance Plan'. I have also configure AlwaysOn High Availability to that server .There is 5 databases in the ...
0
votes
0answers
301 views
Maintenance Plan Transaction Log Backup [duplicate]
I have a backup device set for my transaction log so the sets are contained in 1 file.
I have this set to append, is this correct or should it be overwrite in the plan?
After the full backup is taken ...
0
votes
0answers
255 views
Can maintenance plans be used in SQL Server multiserver (Master-Target servers) administration?
Since I failed to configure SQL Server 2012 Multiserver (Master and Target Servers) administration, I am eager to understand whether it (setting Master and Target servers) would permit to send from ...
-1
votes
1answer
163 views
Transaction Log Backup during Index Rebuild and Integrity Maintenance Jobs
Brent Ozar mentioned there is nothing wrong about conducting transaction log backups during full backups.
https://www.brentozar.com/archive/2015/12/what-happens-to-transaction-log-backups-during-full-...
