SQL Server Performance Forum – Threads Archive

Mandatory Maintenance Plans

What are the mandatory maintenance plan should be scheduled on the production server? Thanks,
Bala

Database backups
Transaction log backups
– copy both to standby server and restore in order to ensure the backup is consistent & valid. – Script database on weekly basis if the schema is chaning rapidly.
– store copy of logins on standby server in the event of disaster recovery
.
.
.
.
many things association with high availability & Business continuity. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

– Defragmentation of tables/indexes
– Update statistics
– Running DBCC CHECKDB…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

1. Update statistics
2. Index rebuild
3. DB Integrity check
4. Shrink d/b’s (not frequently if you have enabled auto growth) Satya

….. [<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />] visit SSP site regularly…. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com</a> <center>This posting is provided AS IS with no rights for the sake of knowledge sharing. <hr noshade size="1">The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.</center>

Thanks All, So far, I have scheduled the following on production server: 1. Backup, Differential and Log – As per the Backup strategy
2. DBCC CheckDB – Weekly
3. Update Statistics – Weekly Can someone advice me on what frequency the each maintenance plan should be scheduled please? I have 64 bit operating system on production and I came to know that the sql mail is not supported. But my company wants only SQL mail to be configured on this production server. Is there any workaround to make it work on 64 bit? Thanks,
Bala

1,2,3 – ok Take help of Database mail in this case for SQL 2005 and if not test out Notification services & service broker for such communitation purpose. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

]]>