No announcements
Found 1778312 threads
-
0 Votes
Automate the creation of a maintenance plan sql server 2008
Maintenance plans are SSIS packages.Answered | 1 Replies | 2751 Views | Created by dcsalvagnini - Thursday, June 21, 2012 4:54 PM | Last reply by Chuck Pedretti - Thursday, June 21, 2012 6:23 PM -
2 Votes
SQL SERVER 2012 Maintenance Plan
Then you are connected to a different SQL Server instance and the plans have been created on an other instance.Answered | 8 Replies | 2715 Views | Created by DBA DEVELOPER - Tuesday, April 29, 2014 2:26 PM | Last reply by DBA DEVELOPER - Wednesday, April 30, 2014 9:33 AM -
2 Votes
Maintenance Task
. :-)Tibor Karaszi, SQL Server MVP | web | blogAnswered | 11 Replies | 1812 Views | Created by winoa - Wednesday, October 9, 2013 10:14 AM | Last reply by Shanky_621 - Tuesday, November 5, 2013 6:16 PM -
0 Votes
Maintenance Cleanup task NOT deleting files
SQL Server 2005 SP2Answered | 11 Replies | 13898 Views | Created by Mel100 - Monday, March 12, 2007 5:56 PM | Last reply by Gary - hot bass - Wednesday, March 16, 2011 11:25 AM -
0 Votes
SQL Server 2008 R2 STD Version Failed Maintenance plan task
You mention that this is a maintenance plan and that you are doing a rebuild.Answered | 1 Replies | 7941 Views | Created by Bamaris - Friday, February 11, 2011 6:00 PM | Last reply by Richard Douglas - Friday, February 11, 2011 10:29 PM -
0 Votes
SQL Server always-on maintenance plans
Index defragmentation Update statatistic All changes will replicate on all SQL Server in AG or we should run this on each of ...Answered | 3 Replies | 1850 Views | Created by Michal Machniak - Friday, September 9, 2016 1:49 PM | Last reply by Shanky_621 - Friday, September 9, 2016 3:20 PM -
0 Votes
SQl server email on Maintenance job status
Once that is done, and you've verified that it is working, add a "Notify Operator" task to the maintenance plan.Answered | 1 Replies | 6033 Views | Created by Munna66 - Saturday, May 16, 2009 10:21 PM | Last reply by Aaron Alton - Saturday, May 16, 2009 11:17 PM -
5 Votes
Exporting SQL Maintenance Plans
" In SQL Server 2005 , I can not find the Import or Export on the Maintenance Plan Sivaprasad S http://sivasql.blogspot.com Please ...Answered | 14 Replies | 63870 Views | Created by MChamber - Thursday, June 16, 2005 2:22 PM | Last reply by Nithyakalyani - Tuesday, August 30, 2016 10:50 AM -
0 Votes
Maintenance cleanup task does not delete older files
Hi dbatsql, On the Maintenance Cleanup Task, check your setting for 'File extension'.Answered | 1 Replies | 8376 Views | Created by dbatsql2011 - Friday, December 9, 2011 6:55 PM | Last reply by Maggie Luo - Monday, December 12, 2011 7:30 AM -
0 Votes
Maintenance Plan Execute T-SQL Task - How to fail
I don't know how the SSIS engine that executes this Execute SQL Task does it, but this is where I would start experimenting.Answered | 2 Replies | 5975 Views | Created by Sql Dude - Monday, September 26, 2011 9:48 PM | Last reply by TiborK - Thursday, September 29, 2011 7:11 AM -
0 Votes
Can't update Maintenance Plans in SQL Server 2012
Hi, Do you mean the "ok" button is missing from the Back Up Database Task dialog?Answered | 5 Replies | 3351 Views | Created by David the Scot - Wednesday, April 30, 2014 6:06 PM | Last reply by David the Scot - Thursday, May 1, 2014 1:57 PM -
0 Votes
SQL Server 2008 R2 maintenance plan issue
Thanks for all helps from SQL community.Answered | 3 Replies | 4947 Views | Created by aaditya2000 - Wednesday, August 17, 2011 7:51 PM | Last reply by aaditya2000 - Thursday, September 1, 2011 10:09 PM -
0 Votes
Cleanup task /xp_delete_file doesn't delete maintenance reports in SQL Server 2012 (German)
Why don't you think over to change classic SQL Server's Maintenace Plans in favour or some solution totally based on T-SQL like Olla's one?Answered | 4 Replies | 2623 Views | Created by Johann Weskandt (Asseco) - Friday, January 15, 2016 10:02 AM | Last reply by Enric Vives - Wednesday, August 24, 2016 10:54 AM -
3 Votes
Maintenance Plans Notify Task Issue
https://docs.microsoft.com/en-us/sql/relational-databases/database-mail/configure-sql-server-agent-mail-to-use-database-mail ...Answered | 9 Replies | 781 Views | Created by Dan Bigelow - Thursday, October 26, 2017 3:10 PM | Last reply by Tom Phillips - Friday, October 27, 2017 5:07 PM -
0 Votes
Importing SQL Server 2005 Maintenance Plans Into SQL Server 2008
Upgrading (migrating) from a separate SQL Server 2005 instance to a SQL Server 2008 instance (your scenario).Answered | 1 Replies | 8835 Views | Created by thecoleman - Thursday, June 4, 2009 3:12 PM | Last reply by JasonHowell - Saturday, July 4, 2009 1:44 PM -
0 Votes
Database maintenance tasks SQL 2008 R2 environment
All you need to do is run the Maintenance Plan Wizard http://msdn.microsoft.com/en-us/library/ms191002.aspx and follow the steps.Answered | 2 Replies | 5360 Views | Created by SIRIGINEEDI - Thursday, June 23, 2011 5:38 AM | Last reply by Peter.Tang - Thursday, June 23, 2011 6:45 AM -
0 Votes
Maintenance task error
This should be the last solution in my opinion (it is always a solution to re-install the whole computer from the operating system to the SQL Server and each application ...Answered | 5 Replies | 1977 Views | Created by MLarouche1 - Tuesday, December 10, 2013 9:54 PM | Last reply by pituach - Wednesday, December 11, 2013 3:56 PM -
0 Votes
SQL Server Maintenance Plan Issue
When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.Answered | 5 Replies | 1398 Views | Created by mrvsfly - Wednesday, February 25, 2015 3:48 AM | Last reply by Lydia Zhang - Thursday, February 26, 2015 7:46 AM -
4 Votes
Maintenance Cleanup task not functioning properly???
(Grayed out) So right click the task of your maintenance plan and make sure it is enabled !Answered | 25 Replies | 47005 Views | Created by Carl Berger - Tuesday, May 16, 2006 3:21 PM | Last reply by Neosys - Tuesday, October 23, 2012 3:48 PM -
6 Votes
SQL Maintenance Plans Jobs
Hi, Have you checked SQL Server Agent service account?Answered | 6 Replies | 4473 Views | Created by SartyCH - Friday, August 24, 2012 12:09 PM | Last reply by SartyCH - Monday, September 3, 2012 10:29 AM
No announcements