March 26, 2009 at 12:34 pm
Is any one can give me a good routine on the maintance jobs, every day and every week. What is first runs and last.Thank you
March 26, 2009 at 12:49 pm
yulichka (3/26/2009)
Is any one can give me a good routine on the maintance jobs, every day and every week. What is first runs and last.Thank you
as always "it depends".
Check this out:
http://www.sqlservercentral.com/Forums/Topic683877-146-1.aspx#bm684479
similar discussion
March 26, 2009 at 1:25 pm
Basic starting point - adjust as needed...
Daily Plan (All User Databases)
Integrity Check
Backup
Remove Old Backup Files
Remove Old Transaction Log Backup Files
Daily Plan (All System Databases)
Integrity Check
Backup
Remove Old Backup Files
Hourly Plan (All User Databases - full recovery model)
Transaction Log Backup
Weekly Plan (All User Databases)
Rebuild/Reorganize Indexes
Update Statistics (if reorganizing indexes, update statistics with full scan - else use sp_updatestats to only update stats that need to be updated.)
In each plan, add a Notify Operator task, connect each task to the notify operator task, change the constraint to failure and modify the option for multiple constraints to a Logical OR...this will make the constraint lines a dashed red line.
Each step in the above would be connected with a success constraint in the order I layed out.
This should be a good starting point - but, you will need to adjust as needed.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 26, 2009 at 1:32 pm
I want to know the schedule,
Optimization job:
Optimization Job for SAVVIS Full Recovery Model User DB Maintenance Plan Occurs every week on Sunday at 1:40:00 AM.
Optimization Job for SAVVIS Simple Recovery Model User DB Maintenance Plan Occurs every week on Sunday at 1:20:00 AM.
Optimization Job for SAVVIS System DB Maintenance Plan Occurs every week on Sunday at 1:00:00 AM.
I run ingegrity job:
Integrity Checking Job for Full Recovery Model User DB Maintenance Plan Occurs every week on Sunday at 3:00:00 AM.
Integrity Checking Job for Simple Recovery Model occurs every week on Sunday at 2:30:00 AM.
Integrity Check System Databases Occurs every week on Sunday at 2:00:00 AM.
Backup:
Full backup occurs every week on Sunday at 9:00:00 PM.
Simple backup occurs every week at 8:30:00 PM.
Backup SYSTEM Databases occurs every day at 8:00:00 PM
Transaction Log Backup Job for Full Recovery Model User Occurs every day every 4 hour(s) between 12:00:00 AM and 11:59:59 PM.
Is this correct, what else do I need?
March 26, 2009 at 1:39 pm
Those all look like SQL Server 2000 maintenance plan jobs. Are you on SQL Server 2000 or SQL Server 2005?
The outline I provided was based on setting this up in SQL Server 2005.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 26, 2009 at 10:10 pm
Yes, this is 2000
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply