Database Administrators Stack Exchange
Database Administrators Stack Exchange

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.

Workflows created through SQL Server Management Studio that help automate SQL Server maintenance tasks like backups, index rebuilds, and updating statistics. Each plan is comprised of an SSIS package but can be executed directly by the SQL Agent.

131 questions
21
votes
3 answers

Copy maintenance plans to a different server

Is there a way to copy maintenance plans from one SQL Server 2012 to another? Both servers are not accessible via the same copy of Management Studio at the same time (on different networks).
Greg Bala
  • 1,005
  • 3
  • 10
  • 17
13
votes
4 answers

Can I export a maintenance plan without using Integration Services?

I'm trying to export a simple maintenance plan from an SQL Server instance. I want to check the export into source control, and apply the exported maintenance plan to functionally identical instances. StackOverflow and SQL Server Newbie recommend…
Iain Samuel McLean Elder
  • 2,168
  • 4
  • 23
  • 39
12
votes
2 answers

Scripting a maintenance plan

I created a maintenance plan for my SQL Server 2008 R2 using SQL Server Management Studio (SSMS). However, I am unable to export/convert it to a script, in case I need to redo it on another server. Is there a way? If no, will there be a way with a…
carlo.borreo
  • 1,407
  • 5
  • 18
  • 32
10
votes
2 answers

What's the owner of SqlServerAgent job for?

What is the possible use of owner of an SQL Server Agent job, I wonder? Removed, and left it blank and the job still succeeds
Fulproof
  • 1,362
  • 2
  • 25
  • 33
10
votes
1 answer

I/O is frozen on Database & also I/O was resumed on Database on daily basis in log with complete Backup

I would like to say that as on daily basis i got the message in my log file. First The I/O is frozen on Database (DatabaseName) message appears in log. The message is like I/O is frozen on Database (DatabaseName).No User action is required. …
Md Haidar Ali Khan
  • 5,967
  • 9
  • 34
  • 59
9
votes
1 answer

SQL Server Job History Disappears After 5 Days

I feel like this is a silly question but for the life of me, I can't track down what is going on. I have just taken over administration of several servers and on all of them, the job history is being retained for only 5 days. There is a cleanup…
PseudoToad
  • 788
  • 2
  • 10
  • 19
9
votes
1 answer

Best way to backup & truncate transaction logs on a schedule

I'm no DBA, but things being what they are, I have to wear the DBA hat and set up maintenance plans on my SQL Server instance. So for a while I've been having my SSIS overnight process run a Execute SQL Task to perform the backups - basically…
Mathieu Guindon
  • 884
  • 2
  • 7
  • 14
8
votes
4 answers

Why does it take so long to view logs on a server?

I am just trying to look up more verbose information for a maintenance plan task that failed. I open up the log file viewer and check the box to view the logs for my maintenance plan. There are no active filters besides that in this example. Then I…
Matt
  • 343
  • 3
  • 17
7
votes
5 answers

Managing Transaction Log Size using a Maintenance Plan

Are there any best practices for configuring a Maintenance Plan in SQL Server 2008? Currently, I'm removing database backups and transaction logs greater than 40 hours old, then backing them up. Problem I've seen is that the transaction log is…
Neil Knight
  • 627
  • 2
  • 12
  • 21
6
votes
2 answers

Full backup on database creation

When new databases are created the Differential and transaction log backup maintenance plans start failing and sending alerts as full backup is not taken. What could be the best solution to handle it. I tried to do full backup on database created…
shilan
  • 119
  • 3
6
votes
1 answer

What does 'sp_configure allow updates' do?

Today I got an error ( DTSER_FAILURE ) but I could fix it by editing the maintenance plan ( this error is due to the maintenance plan searching for a database that was deleted, and I was using "selected databases" in the setup ). But over the…
Racer SQL
  • 7,004
  • 9
  • 49
  • 101
5
votes
2 answers

Backup Database Task - What's the number at the end of the filename?

When using a SQL Server 2012 EMaintenance Plan for backup purposes, the Backup Database Task creates a unique filename. I understand the format all the way to the final set of numbers. For example, a Full Database Backup initiated via the Backup…
Travis Crooks
  • 55
  • 6
5
votes
2 answers

Run a PowerShell script on a different server - from inside a SQL Server job

I have a procedure to backup SSAS Databases. That is working as a charm. Now my server is filling up with SSAS backups and I would like to delete the backup files that are older than 2 days. to achieve this I am using the following POWERSHELL…
Marcello Miorelli
  • 14,544
  • 46
  • 126
  • 249
5
votes
2 answers

Deploy SQL Server Backup Maintenance Plan in multi-tenant environment

We have a multi-tenant environment in which I've been trying to deploy a standardised maintenance plan across all servers. I've been running into issues importing the maintenance plan properly, as well as issues setting up the correct minimal…
Geekman
  • 153
  • 4
5
votes
2 answers

How to specify a SQL Server maintenance plan subtask to run unconditionally on success or failure of preceding tasks?

I am having a (rather standard) daily maintenance plan created with SQL Server Management Studio Maintenance Plan Wizard. AFAIU, the penultimate task "Back Up Database Task" will be executed only on the success of all preceding tasks. Since the…
Fulproof
  • 1,362
  • 2
  • 25
  • 33
1
2 3
…
8 9