No announcements
Found 2245620 threads
-
0 VotesAlwaysON Maintenance Plan
https://blogs.msdn.microsoft.com/sqlgardner/2012/07/18/sql-2012-alwayson-and-backups-part-1-offloading-the-work-to-a-replica/ ...Answered | 6 Replies | 3699 Views | Created by Mohan Chhapadia - Monday, March 21, 2016 9:57 AM | Last reply by Ashwin Menon - Wednesday, March 23, 2016 11:48 AM
-
2 Votes
SQL Server 2012 AlwaysON backup databases and index maintenance
Full copy-only backups and transaction log backups are performed on the preferred replica.Answered | 3 Replies | 9735 Views | Created by Andrea Caldarone - Thursday, July 5, 2012 9:21 AM | Last reply by Ola Hallengren - Thursday, July 5, 2012 3:08 PM -
0 Votes
SQL Server - Multiple Database backups - Maintenance Plans
Normally backing up medium sized databases (10-200) G in night and 20-25 at a time with single maintenance plan will not have much I/O affect if you have your ...Answered | 2 Replies | 1876 Views | Created by SQL Server - Maintenance Plans - Multiple Database - Friday, April 8, 2016 12:32 PM | Last reply by Shanky_621 - Friday, April 8, 2016 2:29 PM -
2 Votes
BACKUP MAINTENANCE PLAN
Hi Ysabel1111, If you encounter the issue that SQL Server Maintenance plan doesn’t delete backups, please verify the ...Answered | 5 Replies | 1229 Views | Created by Ysabel1111 - Tuesday, March 24, 2015 2:22 AM | Last reply by Lydia Zhang - Wednesday, March 25, 2015 9:03 AM -
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 servers.Answered | 3 Replies | 1843 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
Maintenance Plans when using An AlwaysOn Database Availability Group
Maintenance plans run serially, so this is not a concern from a maintenance plan point of view but more from an index maintenance, log, and network point ...Answered | 3 Replies | 2902 Views | Created by Aetius2012 - Wednesday, July 16, 2014 12:12 PM | Last reply by Sean Gallardy - Wednesday, July 16, 2014 2:35 PM -
0 Votes
SQL database older backup file delete using maintenance plan
Hi Zahid2017, Could you please share some log files generated by maintenance plan?Answered | 4 Replies | 2160 Views | Created by Zahid2017 - Thursday, October 12, 2017 6:41 PM | Last reply by Teige Gao - Thursday, October 19, 2017 6:58 AM -
0 Votes
AlwaysOn Encryption in SQL Server 2016
Hi, We have completely migrated all our environment from SQL Server 2012 to 2016.Answered | 2 Replies | 1336 Views | Created by VijayKSQL - Monday, April 3, 2017 3:09 PM | Last reply by Shanky_621 - Tuesday, April 4, 2017 5:40 AM -
0 Votes
AlwaysON backup question
Do you want to say it's normal to have copy only backups for a database and never backup it using an "ordinary" full backup?Answered | 7 Replies | 1290 Views | Created by MF47 - Tuesday, September 2, 2014 10:03 AM | Last reply by MF47 - Monday, September 8, 2014 10:23 AM -
0 Votes
Best plan for weekly maintenance plan for index, backup.
Ok guys, I have setup my database backup plan.Answered | 7 Replies | 4328 Views | Created by Mayur-DEW - Monday, April 16, 2012 6:25 AM | Last reply by Jeff Williams 3188 - Monday, April 16, 2012 1:19 PM -
0 Votes
Maintenance plan still including my databases in backup
When you made the changes to the maintenance plan and closed it, did it ask you to save the changes?Answered | 3 Replies | 1434 Views | Created by Bill Gayts - Monday, September 23, 2013 8:18 AM | Last reply by Bill Gayts - Tuesday, September 24, 2013 10:20 PM -
0 Votes
SQL 2008 - maintenance plan - changing backup location
Hi Keith, Is the problem solved by the steps above?Answered | 3 Replies | 20647 Views | Created by Keith Naccarato - Wednesday, June 22, 2011 12:33 PM | Last reply by Stephanie Lv - Tuesday, June 28, 2011 9:22 AM -
3 Votes
Maintenance Plan and Backups
>>>Is it just a case of setting up 2 maintenance plans and schedule them accordingly?Answered | 2 Replies | 717 Views | Created by RD12345RD - Wednesday, July 12, 2017 10:44 AM | Last reply by Uri Dimant - Wednesday, July 12, 2017 11:05 AM -
0 Votes
backup maintenance plan
• All transaction log backups taken after the full database backup or the differential backup (if you restore one) and before the ...Answered | 7 Replies | 4650 Views | Created by N.Afache - Thursday, August 23, 2012 9:55 AM | Last reply by Shulei Chen - Tuesday, August 28, 2012 9:12 AM -
0 Votes
SSMS Maintenance Plans for SQL Server 2005 Database Backup Fails.
Hi SQL Experts, I am SharePoint Admin and Also I am now handling the Sql backups and Restore.Answered | 2 Replies | 3574 Views | Created by Aniket SPoint - Wednesday, June 5, 2013 6:59 AM | Last reply by Aniket SPoint - Friday, June 14, 2013 2:03 AM -
0 Votes
Database Maintenance Plans not running
Are all these in same maintenance plan.Answered | 4 Replies | 1378 Views | Created by deftoner08 - Tuesday, October 7, 2014 2:27 PM | Last reply by Satish Kartan, MCITP - Tuesday, October 7, 2014 3:42 PM -
0 Votes
SQL Server 2005 Maintenance Plan failed (Backup)
This error is from maintenance plan.Answered | 8 Replies | 11613 Views | Created by freemascot - Friday, July 24, 2009 5:05 AM | Last reply by Pradeep Adiga - Friday, June 1, 2012 4:17 AM -
0 Votes
AlwaysOn Backups with Verify
was that you were trying to configure backups & for the Backup file validation?Answered | 2 Replies | 933 Views | Created by David the Scot - Monday, August 11, 2014 7:47 PM | Last reply by Rama Udaya - Tuesday, August 12, 2014 11:39 AM -
0 Votes
SQL maintenance plan on Primary and secondary server
I'm not sure what's causing your issue as I haven't used maintenance plans in many years however I would suggest looking at Ola Hallengren's maintenance ...Answered | 2 Replies | 1340 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
Maintenance plan for Mirror database
About how to copy maintenance plans from one Server to other, please follow the steps in the blog below.Answered | 4 Replies | 2269 Views | Created by Vanchan - Saturday, January 17, 2015 7:43 PM | Last reply by Lydia Zhang - Tuesday, January 20, 2015 6:29 AM - Items 1 to 20 of 2245620 Next ›
No announcements
