Maintenance plan for SQL DB maintenance order

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Maintenance plan for SQL DB maintenance order...

Maintenance plan for SQL DB maintenance order

Rate Topic

Display Mode

Topic Options

Author

Message

jamessdba

Posted Sunday, December 02, 2012 11:16 PM

Valued Member

Group: General Forum Members
Last Login: 2 days ago @ 11:36 PM
Points: 72, Visits: 797

Hi,

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

Thanks in advance

Post #1391775

Jayanth_Kurup

Posted Sunday, December 02, 2012 11:21 PM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:43 AM
Points: 1,785, Visits: 1,008

Could you please list the tasks that you perform as part of the maintainence plan

Jayanth Kurup

Post #1391777

jamessdba

Posted Monday, December 03, 2012 12:13 AM

Valued Member

Group: General Forum Members
Last Login: 2 days ago @ 11:36 PM
Points: 72, Visits: 797

Only Full & Trn Backup

Post #1391788

GilaMonster

Posted Monday, December 03, 2012 1:20 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:09 PM
Points: 37,721, Visits: 29,975

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

Jayanth_Kurup

Posted Monday, December 03, 2012 1:27 AM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:43 AM
Points: 1,785, Visits: 1,008

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

jamessdba

Posted Monday, December 03, 2012 2:17 AM

Valued Member

Group: General Forum Members
Last Login: 2 days ago @ 11:36 PM
Points: 72, Visits: 797

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

GilaMonster

Posted Monday, December 03, 2012 4:02 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:09 PM
Points: 37,721, Visits: 29,975

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 »

Permissions