May 26, 2009 at 12:33 pm
I would like to set up maintance job for system and regular db. In what order I should run them and how often.
Thank you
May 26, 2009 at 1:00 pm
I setup separate maintenance plans for system databases and user databases. They are independent from each other.
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
May 26, 2009 at 1:07 pm
In what order jobs are running?
May 26, 2009 at 1:12 pm
Krasavita (5/26/2009)
In what order jobs are running?
I don't understand the question. What jobs - what order?
I have a maintenance plan for the system databases, and a separate plan for the user databases. They are scheduled at different times independent from each other. There is no relationship between the two.
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
May 26, 2009 at 1:20 pm
DB Backup,
Transaction job,
Optimization
Integrity
May 26, 2009 at 1:38 pm
Okay, you are talking about the steps to perform in a maintenance plan.
For system databases, you need the following:
Integrity Check
Backup System Database
Cleanup old backup files
The above should be scheduled daily at whatever time is available during your maintenance window.
For user databases, it really depends upon the database. You need the same above steps and include a rebuild/reorganize indexes and update statistics (optimizations) as needed for each user database.
As for transaction logs - those should be scheduled on a frequent basis depending upon your organizations business requirements and disaster recovery plan. How much data loss can you afford if the server crashes? If you can afford up to 24 hours loss you would use simple recovery model, if you can only afford 5 minutes of data loss - you would use full recovery model and schedule the transaction log backups every 5 minutes. Generally, most of the time we see transaction log backups scheduled every hour. But again, this is really dependent upon your business requirements.
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
May 27, 2009 at 11:46 am
What is 1st goes integrity or optimization? Thank you
May 27, 2009 at 2:46 pm
That depends on when you are scheduling them. If they are part of the daily maintenance, then it would come after the integrity check. If they are scheduled separately - then it doesn't matter.
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
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply