Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Maintenance plan for SQL DB maintenance order Expand / Collapse
Author
Message
Posted Sunday, December 2, 2012 11:16 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 7:00 AM
Points: 78, Visits: 1,015
Hi,

Best maintenance plan order for Production Database(>100GB) sqlserver 2005.

Thanks in advance
Post #1391775
Posted Sunday, December 2, 2012 11:21 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, June 12, 2014 2:04 PM
Points: 1,789, Visits: 1,014
Could you please list the tasks that you perform as part of the maintainence plan

Jayanth Kurup
Post #1391777
Posted Monday, December 3, 2012 12:13 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 7:00 AM
Points: 78, Visits: 1,015
Only Full & Trn Backup
Post #1391788
Posted Monday, December 3, 2012 1:20 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 8:25 AM
Points: 42,492, Visits: 35,560
Those two should be scheduled based on your backup strategy and your SLAs.

You also need integrity checks and index maintenance at a minimum.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1391798
Posted Monday, December 3, 2012 1:27 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, June 12, 2014 2:04 PM
Points: 1,789, Visits: 1,014
I usually prefer not to use a maintainence plan to perform backups. Try using a script instead. Also if you have the option use a third party tool for more reliable and faster backups.

Jayanth Kurup
Post #1391803
Posted Monday, December 3, 2012 2:17 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 7:00 AM
Points: 78, Visits: 1,015
Hi Thanks for updates

Gail please let me know these (integrity checks and index maintenance)tasks before or after Backups.?

And for DB maintenance what else can be done for Production
Post #1391809
Posted Monday, December 3, 2012 4:02 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 8:25 AM
Points: 42,492, Visits: 35,560
Index maintenance whenever you have time. Integrity checks probably before the backup. It's nice to know whether the DB is corrupt or not before backing it up.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1391839
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse