No announcements
Found 1778612 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 | 1450 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 | 923 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 | 11627 Views | Created by Charles Borner - Friday, November 2, 2007 1:35 AM | Last reply by Deepak Rangarajan - Friday, November 2, 2007 1:54 AM -
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 | 6467 Views | Created by NeerajSaini - Tuesday, March 16, 2010 6:14 PM | Last reply by NeerajSaini - Wednesday, March 17, 2010 3:59 PM -
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 | 10746 Views | Created by TheMaestro - Wednesday, July 9, 2008 1:59 PM | Last reply by Fml_70 - Saturday, May 8, 2010 6:35 PM -
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 | 1698 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 | 8247 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
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 | 5994 Views | Created by Richlion - Wednesday, February 25, 2015 11:03 AM | Last reply by Alan Rimer - Sunday, March 29, 2015 6:25 AM -
0 Votes
SQL Server 2012 Maintenance Plans
Hello Tracy, Have you setup the maintenance plan cleanup task this way?Answered | 2 Replies | 2659 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 -
0 Votes
Maintenance Plan task loging
Tibor Karaszi, SQL Server MVP | web | blogAnswered | 3 Replies | 705 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 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 | 6909 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 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 | 1179 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 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 | 943 Views | Created by PradyothanaDP - Thursday, March 29, 2018 12:44 PM | Last reply by PradyothanaDP - Monday, April 2, 2018 3:30 PM -
1 Votes
I hate the maintenance CleanUp task :=)
I cant follow the solution your giving. to delete the files in D:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG.Answered | 9 Replies | 13665 Views | Created by Armando2 - Friday, May 4, 2007 8:05 PM | Last reply by Archana Balakrishnan - Tuesday, December 8, 2009 4:07 AM -
1 Votes
SQL Server Maintenance Plan
But I think you have an entry called "SQL Server agent".Answered | 3 Replies | 7254 Views | Created by Abdelrahman Azazi - Thursday, March 4, 2010 11:14 AM | Last reply by TiborK - Thursday, March 4, 2010 5:09 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 | 14570 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
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 | 5254 Views | Created by Sam1980 - Friday, May 13, 2011 7:09 PM | Last reply by Uri Dimant - Sunday, May 15, 2011 1:19 PM -
2 Votes
Maintenance Task
. :-)Tibor Karaszi, SQL Server MVP | web | blogAnswered | 11 Replies | 1690 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
Automate the creation of a maintenance plan sql server 2008
Maintenance plans are SSIS packages.Answered | 1 Replies | 2636 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 | 2468 Views | Created by DBA DEVELOPER - Tuesday, April 29, 2014 2:26 PM | Last reply by DBA DEVELOPER - Wednesday, April 30, 2014 9:33 AM - Items 1 to 20 of 1778612 Next ›
No announcements
