I stepped into this job in the second week of April. They had not had a backup since December. So I immediately did a full backup.
This is a 24 hour 7 day a week shop with no scheduled downtimes for maintenance.
The only thing I have succeeded in implementing so far is backups and I have been able to restore those backups to another SQL machine.
What I need to know is what things should be in a maintenance plan?
Database integrity checks?
Rebuilding indexes?
In the 5 years these databases have been up and running - nothing whatsoever has been done.
Issues recently have been identified that lead me to believe that this long overdue maintenance needs to be done.
People running reports after data entry sometimes don't see the new data and running the same report later, the new data shows up.
Also running a report after entering new data works fine, then running the same exact report later and the new data is missing.
So I need to implement maintenance immediately.
Please advise and give me some sample scripts to try.
This is a 24 hour 7 day a week shop with no scheduled downtimes for maintenance.
The only thing I have succeeded in implementing so far is backups and I have been able to restore those backups to another SQL machine.
What I need to know is what things should be in a maintenance plan?
Database integrity checks?
Rebuilding indexes?
In the 5 years these databases have been up and running - nothing whatsoever has been done.
Issues recently have been identified that lead me to believe that this long overdue maintenance needs to be done.
People running reports after data entry sometimes don't see the new data and running the same report later, the new data shows up.
Also running a report after entering new data works fine, then running the same exact report later and the new data is missing.
So I need to implement maintenance immediately.
Please advise and give me some sample scripts to try.