No announcements
Found 1778367 threads
-
2 VotesSQL Maintenance Tasks
Second MP will start from 12 PM to 11:59 PM and location of back file would be E drive.For each in MP add a clean up task .Answered | 11 Replies | 1524 Views | Created by VijayKSQL - Wednesday, November 6, 2013 9:11 AM | Last reply by Jingyang Li - Wednesday, November 6, 2013 4:03 PM
-
0 Votes
SQL Maintenance tasks best practice
https://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html As far as checking database integrity once a week should ...Answered | 1 Replies | 1003 Views | Created by Johnmclain - Wednesday, October 8, 2014 2:52 PM | Last reply by Ashwin Menon - Wednesday, October 8, 2014 3:20 PM -
0 Votes
Problem with SQL Server maintenance cleanup tasks
In the Clean up Task in the place where you specified file extension you need to give "bak" incase if you had accidentally given it as ".bak" it might not work.Answered | 1 Replies | 11895 Views | Created by Charles Borner - Friday, November 2, 2007 1:35 AM | Last reply by Deepak Rangarajan - Friday, November 2, 2007 1:54 AM -
2 Votes
Unable to Create SQL Maintenance Tasks
I am having problems creating maintenace tasks in the Maintenance Applet in Server Management Studio.Answered | 7 Replies | 10842 Views | Created by TheMaestro - Wednesday, July 9, 2008 1:59 PM | Last reply by Fml_70 - Saturday, May 8, 2010 6:35 PM -
0 Votes
SQL Server Maintenance Plan
I have written a step-by-step notes on how to create a maintenance plan in SQL server 2005.Answered | 4 Replies | 6591 Views | Created by NeerajSaini - Tuesday, March 16, 2010 6:14 PM | Last reply by NeerajSaini - Wednesday, March 17, 2010 3:59 PM -
0 Votes
Maintenance task plans in toolbox grayed out (SQL-Server 2012 Enterprise)
I just had the exact same issue with the Toolbox "Maintenance Plan Tasks" being grayed out and no design window.Answered | 11 Replies | 6206 Views | Created by Richlion - Wednesday, February 25, 2015 11:03 AM | Last reply by Alan Rimer - Sunday, March 29, 2015 6:25 AM -
1 Votes
BHM: Maintenance tasks not working
Hi, You need to update BHM using its self-update feature - see my post in the BHM blog ...Answered | 1 Replies | 1830 Views | Created by Trombone - Monday, October 21, 2019 10:54 PM | Last reply by JPAUC - Thursday, October 31, 2019 9:49 PM -
0 Votes
Maintenance task in SQL
Further if you have SQL Server 2005/2008, defrag the latest partition only.Answered | 3 Replies | 8314 Views | Created by Krishna_shree - Wednesday, April 27, 2011 7:10 AM | Last reply by subbugvv - Thursday, April 28, 2011 9:30 AM -
0 Votes
SQL Server 2005 - Maintenance Task doesn't delete BAK
Hi, There is a famous issue with SQL Server 2005 RTM for Maintenance Plans & others which got fixed in SQL Server 2005 SP2.Answered | 5 Replies | 6968 Views | Created by TossLove - Monday, May 23, 2011 11:52 AM | Last reply by GURSETHI - Monday, May 23, 2011 2:35 PM -
0 Votes
SQL Server 2012 Maintenance Plans
Hello Tracy, Have you setup the maintenance plan cleanup task this way?Answered | 2 Replies | 2761 Views | Created by Tracy R. Beekman - Wednesday, May 8, 2013 7:03 PM | Last reply by Tracy R. Beekman - Thursday, May 9, 2013 1:08 PM -
1 Votes
Server Maintenance Plan Failed on SQL 2005 SP2
The SQL server and SQL server agent were localsystem and they are now different domain accounts.Answered | 10 Replies | 14684 Views | Created by Naga_78 - Monday, July 21, 2008 6:44 PM | Last reply by Aviel Iluz - Monday, August 10, 2009 5:40 AM -
0 Votes
Automate the creation of a maintenance plan sql server 2008
Maintenance plans are SSIS packages.Answered | 1 Replies | 2708 Views | Created by dcsalvagnini - Thursday, June 21, 2012 4:54 PM | Last reply by Chuck Pedretti - Thursday, June 21, 2012 6:23 PM -
0 Votes
Maintenance Plan task loging
Tibor Karaszi, SQL Server MVP | web | blogAnswered | 3 Replies | 780 Views | Created by sakurai_db - Thursday, June 19, 2014 8:46 AM | Last reply by TiborK - Friday, June 20, 2014 11:47 AM -
0 Votes
SQL Server Maintenance
I use rebuild/reorg/update stats script three times a week and and twice a week dbcc integrity check Best Regards,Uri Dimant SQL Server ...Answered | 8 Replies | 1059 Views | Created by PradyothanaDP - Thursday, March 29, 2018 12:44 PM | Last reply by PradyothanaDP - Monday, April 2, 2018 3:30 PM -
0 Votes
SQL maintenance plan on Primary and secondary server
I suspect that you save the backup files on a network shared folder, if so, please verify the SQL Server Agent account has permission to ...Answered | 2 Replies | 1280 Views | Created by Manish Joisar - Tuesday, April 14, 2015 2:47 PM | Last reply by Lydia Zhang - Wednesday, April 15, 2015 6:48 AM -
0 Votes
SQL maintenence
Looks like you're right, it does however contain an A to Z list of tasks a DBA should be performing regularly.Answered | 6 Replies | 5317 Views | Created by Sam1980 - Friday, May 13, 2011 7:09 PM | Last reply by Uri Dimant - Sunday, May 15, 2011 1:19 PM -
1 Votes
SQL 2012 SP1 Task Name Missing from Maintenance Plan History
Add the Task Name for each task.Answered | 6 Replies | 5910 Views | Created by benco5000 - Sunday, July 14, 2013 3:47 PM | Last reply by SSG92 - Monday, September 9, 2019 3:08 PM -
1 Votes
SQL Server runtime licensing and maintenance
You can chat with them online here: https://www.microsoft.com/en-us/sql-server/sql-server-2016-pricing However, it ...Answered | 4 Replies | 2487 Views | Created by Uwe K, - Wednesday, October 26, 2016 5:16 PM | Last reply by davidbaxterbrowne - Friday, October 28, 2016 8:34 PM -
2 Votes
Maintenance Task
. :-)Tibor Karaszi, SQL Server MVP | web | blogAnswered | 11 Replies | 1755 Views | Created by winoa - Wednesday, October 9, 2013 10:14 AM | Last reply by Shanky_621 - Tuesday, November 5, 2013 6:16 PM -
1 Votes
SQL Server Maintenance Plan
But I think you have an entry called "SQL Server agent".Answered | 3 Replies | 7411 Views | Created by Abdelrahman Azazi - Thursday, March 4, 2010 11:14 AM | Last reply by TiborK - Thursday, March 4, 2010 5:09 PM - Items 1 to 20 of 1778367 Next ›
No announcements
