No announcements
Found 1740947 threads
-
0 VotesSQL server maintenance task
Hey friends, My problem is not solved, could you please tell me on weekly basis what my maintenance task should include. I have 15 databases ...Answered | 6 Replies | 6026 Views | Created by Mayur-DEW - Monday, June 11, 2012 9:54 AM | Last reply by Sean Massey - Tuesday, July 3, 2012 7:39 AM
-
0 Votes
SQL Server 2005 Maintenance Cleanup Task
When using "SQL Server 2005 Maintenance Cleanup Task" within a Maintenance Plan, how do you specify the "search folder" when the .bak ...Answered | 1 Replies | 8482 Views | Created by TopTN - Thursday, April 6, 2006 1:24 PM | Last reply by Gops Dwarak - Sunday, April 9, 2006 3:51 AM -
0 Votes
SQL Server 2005 - Maintenance Task doesn't delete BAK
Hi every one. I have a SQL Server 2005 (9.00.1399.00) installed in Windows Server 2003 SP1. As i said in title the Maintenance ...Answered | 5 Replies | 6865 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 2005 Maintenance Cleanup Task gives error
Hello All, I am new to Sql Server 2005 and am setting up a Maintenance Plan. I inherited an existing setup of SqlServer. All the Maintenance ...Answered | 2 Replies | 5700 Views | Created by jsmShawn - Thursday, February 19, 2009 6:15 PM | Last reply by jsmShawn - Friday, February 20, 2009 6:05 PM -
0 Votes
SQL Server Maintenance Task
SQL Server 2012 and the agent is running, and other maintenance tasks are working. I added the maintenance workflow directly from the interface and it ...Proposed | 5 Replies | 1062 Views | Created by Luckett Logistics - Tuesday, April 28, 2015 4:59 PM | Last reply by Luckett Logistics - Thursday, May 7, 2015 1:43 PM -
0 Votes
SQL Server 2008 R2 Maintenance Task (Backup) sometimes Fails with Error 0x80004003
The built-in maintenance plan functionality for SQL Server is really only suitable for the most simple of database environments. If you are ...Answered | 6 Replies | 7031 Views | Created by Hacky_J - Wednesday, July 13, 2011 11:09 AM | Last reply by Hacky_J - Thursday, July 14, 2011 6:30 AM -
0 Votes
SQl Server 2008 Maintenance Plan Cleaup up Task
Hi, I created a SQL Server 2008 Maintenance Plan Cleaup up Task some time back and it was just working fine. However, suddenly the ...Answered | 7 Replies | 3993 Views | Created by SQLServerStuff - Thursday, August 4, 2011 10:43 AM | Last reply by Balmukund - Thursday, August 4, 2011 12:22 PM -
1 Votes
Best practice maintenance task in sql server 2012.
Hi All, Can u anyone suggest me for best practice maintenance task in sql server ...Answered | 2 Replies | 2895 Views | Created by Ratheesh kumar - Friday, March 1, 2013 10:53 AM | Last reply by Ratheesh kumar - Saturday, March 2, 2013 10:05 AM -
0 Votes
Cleanup task /xp_delete_file doesn't delete maintenance reports in SQL Server 2012 (German)
Hi Johann, I test the scenario as yours in SQL Server 2012 SP3 which is a English installation, everything works as expected. The cleanup Task in ...Answered | 4 Replies | 2458 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 -
0 Votes
SQL Server 2008 R2 STD Version Failed Maintenance plan task
We have just upgrade to SQL Server 2008 R2 Standard Edition, and set up a nightly maintenanceAnswered | 1 Replies | 7797 Views | Created by Bamaris - Friday, February 11, 2011 6:00 PM | Last reply by Richard Douglas - Friday, February 11, 2011 10:29 PM -
5 Votes
Use Maintenance task in SQL Server 2005 to Reindex selected indexes by their fragmentation percentage
Hi, I was wondering if there was a way to use the Maintenance Task in Sql Server 2005 to rebuild only those indexes that ...Answered | 4 Replies | 5911 Views | Created by Pskubal - Tuesday, June 21, 2011 9:47 PM | Last reply by Pskubal - Friday, June 24, 2011 2:43 PM -
0 Votes
Maintenance Clanup Task - fails - SQL Server 2008 R2 (sp1) to delete BAK on C:\Archive 14 days old
problem in execute the Maintenance Plan, please post the error messages. Refer to: Maintenance Cleanup Task: httpAnswered | 3 Replies | 5633 Views | Created by RobX - Monday, August 20, 2012 5:35 PM | Last reply by chandra sekhar pathivada - Monday, March 3, 2014 3:43 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. I found some one had installed a newer version of ...Answered | 11 Replies | 5786 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
How to configure report through SQL Server maintenance Plan?
Hello Kalyan, The error message is pretty clear: The SQL Server-Agent, which executes the maintenance plan, don't have permissions to ...Answered | 3 Replies | 3376 Views | Created by Kalyan Chakravarthi (MCP) - Monday, August 12, 2013 3:17 PM | Last reply by Olaf Helper - Monday, August 12, 2013 6:05 PM -
0 Votes
SQL Server 2005 (X64) Maintenance Clean Up Task Using Hours Option for File Age
I'm running into an issue with SQL Server 2005 64-bit and the maintenance clean up tasks. I have it set up to delete any transaction logs or backups older than 12 ...Answered | 1 Replies | 7271 Views | Created by ddubya1205 - Thursday, September 16, 2010 1:45 PM | Last reply by Mohit K. Gupta - Thursday, September 16, 2010 3:41 PM -
6 Votes
Sql Maintenance Plan Error
Microsoft(R) Server Maintenance Utility (Unicode) Version 10.50.2500 Report was generated on "MSql\track111". Maintenance ...Answered | 6 Replies | 4023 Views | Created by Nani55 - Monday, July 9, 2012 3:34 PM | Last reply by Nani55 - Thursday, July 12, 2012 6:47 PM -
0 Votes
Does Index Rebuild Maintenance task in SQL Server 2005 to defrag indexes for BizTalk Databases supported?
You can achieve 99.999 percent availability in its BizTalk Server environments, even during periods of scheduled maintenance.Thiago Almeida - http://connectedthoughts.wordpress.comAnswered | 7 Replies | 6119 Views | Created by Garyreeds - Friday, August 28, 2009 7:55 AM | Last reply by Thiago Antonio Brancher de Almeida - Saturday, August 29, 2009 3:34 AM -
1 Votes
How do you manually clear Maintenance Plan History in SQL 2005?
Hi, Okay. So when setting up Maintenance Plans for SQL 2005, I know there is a Task called "History Cleanup Task". In ...Answered | 3 Replies | 15583 Views | Created by Rashiki777 - Tuesday, December 14, 2010 8:07 PM | Last reply by Kadir Evciler - Wednesday, December 22, 2010 9:50 AM -
0 Votes
SQL maintenance Plan to delete file from network path
.aspx http://blog.sqlauthority.com/2014/11/26/sql-server-maintenance-plan-maintenance-cleanup-task-not-deleting-files/ ...Answered | 1 Replies | 38 Views | Created by Anonymous - Thursday, May 12, 2016 7:28 AM | Last reply by Anonymous - Thursday, May 12, 2016 8:07 AM -
0 Votes
Maintenance log shows success but sql agent job history says failed, SQL log shows no error
Why there is SSIS error message on SQL maintenance job hisotry. the maintenance log in C:\Program Files\Microsoft SQL ...Answered | 1 Replies | 5167 Views | Created by George Zhou - Wednesday, June 6, 2012 3:09 AM | Last reply by Sean Massey - Wednesday, June 6, 2012 4:00 AM - Items 1 to 20 of 1740947 Next ›
No announcements
