Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Optimize Database/best practices
- Thread starter 19972003
- Start date
ptheriault
IS-IT--Management
You should perform the following tasks daily/weekly or even monthly depending on the size and use of your db.
Backup database (if recovery model if full backup Transaction log as well)
Update stats
DBCC CHECKDB
Rebuild indexes
You should try a restore of your backups to a test server to make sure they are valid.
- Paul
- If at first you don't succeed, find out if the loser gets anything.
Backup database (if recovery model if full backup Transaction log as well)
Update stats
DBCC CHECKDB
Rebuild indexes
You should try a restore of your backups to a test server to make sure they are valid.
- Paul
- If at first you don't succeed, find out if the loser gets anything.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question