No announcements
Found 2245628 threads
-
1 VotesSQL Server Maintenance Plan
But I think you have an entry called "SQL Server agent".Answered | 3 Replies | 7577 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
SQL database backup on network share using maintenance plan
I believe that you are describing the "Back Up Database Task" form.Answered | 4 Replies | 6464 Views | Created by Akshay Pate - Thursday, March 21, 2013 11:15 AM | Last reply by Akshay Pate - Saturday, March 23, 2013 6:55 PM -
0 Votes
Database Full backup fails on the maintenance plan task
You can still restore the full database backup even in changing the recovery model..Answered | 3 Replies | 11646 Views | Created by Naga1982 - Friday, November 28, 2008 5:34 PM | Last reply by Deepak Rangarajan - Tuesday, December 2, 2008 9:25 AM -
0 Votes
SQL 2016 High Availability backup recovery configuration
Extract from SQL 2016 licensing guide: 'The secondary server used for failover support does not need to be separately licensed for SQL Server as long as ...Answered | 2 Replies | 903 Views | Created by Brad1326 - Wednesday, February 8, 2017 7:55 PM | Last reply by KevinNicholas - Wednesday, February 8, 2017 8:42 PM -
0 Votes
SQL Maintenance Plan Wizard
For DB mirroring you need to take full backup of database then transaction log backup and then restore it on mirror server with no recovery.Answered | 3 Replies | 2349 Views | Created by nbctcp2 - Friday, February 21, 2014 2:49 AM | Last reply by Shanky_621 - Friday, February 21, 2014 10:00 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 | 6783 Views | Created by NeerajSaini - Tuesday, March 16, 2010 6:14 PM | Last reply by NeerajSaini - Wednesday, March 17, 2010 3:59 PM -
1 Votes
File backups from Maintenance Plan (2008 R2)
The instructions to set it up are given in this link.Answered | 3 Replies | 1027 Views | Created by Ole Drews Jensen - Tuesday, October 2, 2018 7:47 PM | Last reply by TiborK - Wednesday, October 3, 2018 12:58 PM -
2 Votes
sql 2016 error when seting up maintenance plan for the first time
A failure on one non-critical database can result in all backups failing the next night because of a full disk.Answered | 18 Replies | 14486 Views | Created by rick sroka - Tuesday, November 1, 2016 12:07 PM | Last reply by HariomVats87 - Tuesday, July 10, 2018 11:11 AM -
0 Votes
SQL 2016 SP1 Multiple Login Failed when running a maintenance plan using SQL Auth
Hi John, I also found a relevant issue here:Answered | 1 Replies | 1344 Views | Created by John Ellenbrook - Friday, May 18, 2018 10:14 AM | Last reply by Xi Jin - Monday, May 21, 2018 7:11 AM -
6 Votes
SQL Maintenance Plans Jobs
The problem was with the service account running on the maintaince job.Answered | 6 Replies | 4598 Views | Created by SartyCH - Friday, August 24, 2012 12:09 PM | Last reply by SartyCH - Monday, September 3, 2012 10:29 AM -
0 Votes
Cannot delete backup maintenance plan
That's a connectivity error and has nothing to do with maintenance plans per se.Answered | 2 Replies | 1249 Views | Created by Pitou H - Saturday, January 23, 2016 9:09 AM | Last reply by Erland Sommarskog - Saturday, January 23, 2016 10:50 AM -
1 Votes
Database Backup Maintenance Question
This job should run a command file or PowerShell script file to take care of creating folders by date and moving the backups taken by the 'Back Up Database Task', of ...Answered | 6 Replies | 5571 Views | Created by Milind Saraswala - Friday, September 21, 2012 3:40 PM | Last reply by Victor1988 - Tuesday, November 5, 2013 6:46 AM -
0 Votes
sql 2005 Maintenance Plan Issue
THanks Zoran, we are struggling since one week and by registering the DLL maintenance plan started working and we could able to take the prod Backups to Disk.Answered | 23 Replies | 22003 Views | Created by edm2 - Friday, August 4, 2006 2:42 PM | Last reply by Kalim Syed - Friday, August 2, 2013 4:38 PM -
0 Votes
Maintenance plan to backup database to remote location not in the same domain
Hi SingChung, When we use maintenance plan to backup database to remote location that is in different domain, we can use pass ...Answered | 5 Replies | 3643 Views | Created by SingChung - Friday, December 4, 2015 3:22 AM | Last reply by Lydia Zhang - Wednesday, December 9, 2015 8:13 AM -
0 Votes
Maintenance Plan
Hi SSG92, For the task of checking database integrity, please refer to MS official document, please refer toAnswered | 2 Replies | 1199 Views | Created by SSG92 - Thursday, November 14, 2019 6:58 AM | Last reply by Cathy Ji - Friday, November 15, 2019 5:50 AM -
2 Votes
Maintenance Plan Cleanup Task not deleting backup files
where is the "option" in the maintenance plan cleanup task?Answered | 9 Replies | 25648 Views | Created by RayBCCUL - Monday, March 5, 2012 5:44 PM | Last reply by Peter_D503 - Monday, November 3, 2014 1:04 AM -
0 Votes
SQL Server 2016/2017 Standard AlwaysOn and DR
However, what would be the best solution to have AlwaysOn and DR at the same time with SQL Server 2016 Standard?Answered | 16 Replies | 1800 Views | Created by gee_vicencio - Wednesday, May 1, 2019 4:27 PM | Last reply by Shanky_621 - Thursday, May 2, 2019 9:55 AM -
0 Votes
Help with SQL 2008 Maintenance Plan
I have updated our maintenance plan.Answered | 4 Replies | 1031 Views | Created by P. Jackman - Thursday, December 27, 2018 8:48 PM | Last reply by P. Jackman - Thursday, January 3, 2019 7:15 PM -
2 Votes
SQL SERVER 2012 Maintenance Plan
No Olaf I connected to the right Instance but its not displaying in maintenance plan folder when I connect to database engine ...Answered | 8 Replies | 2814 Views | Created by DBA DEVELOPER - Tuesday, April 29, 2014 2:26 PM | Last reply by DBA DEVELOPER - Wednesday, April 30, 2014 9:33 AM -
0 Votes
Maintenance Plans
In the maintenance plan, have you selected the check box in backup task which creates separate folder(Create a sub-directory for each database) for each ...Answered | 5 Replies | 2265 Views | Created by Rajesh.Mullapudi - Monday, April 1, 2013 2:36 PM | Last reply by KevinNicholas - Wednesday, April 3, 2013 5:55 AM
No announcements
