Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tripleDot
Starting Member
6 Posts |
 Posted - 2010-04-30 : 01:35:14
|
Hello peps, new in this forum.  I've worked with SQL for quite a bit now but mostly as a programmer. I've now moved to DB administration, so I'd like to know what protocols or procedures you do to ensure your database don't go bonkers... well at least some preventive maintenance. I've read about DBCC CHECKDB/CHECKALLOC/CHECKTABLE/CHECKCATALOG but am not really sure how to use them. I don't mean syntax but rather when to schedule them, how often do I run them, what combinations, or should I run them only when no one else (except me, the Admin) is using the database, that sort of stuff. What about the log files, how much attention should I give them?Do you people write scripts that runs all these procedures? Any other procedures or commands that you include? Like using UPDATE STATISTICS or reindexing to supplement or compliment? Or what should not be used together with or which should come first? Basically, a simple step-by-step procedure a DB Administration should know.Another question I'd like to know is how do you check the integrity of your DB backup files? Do you have a separate SQL server where you restore these backups just to check their status? Or do you use tools such as third party softwares or those that came with SQL Server?Thanks. |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2010-04-30 : 11:47:31
|
| 1. Look at member TKizers blogs....VERY good advice and scipts available.2. backups3. testing backups!4. security5. optimisations6. change control processessearch here for other discussions...and also look at the FAQ. |
 |
|
|
tripleDot
Starting Member
6 Posts |
Posted - 2010-05-03 : 02:26:30
|
| Thanks Andrew, I've bookmarked Tara's blog. |
|
|
|
|
|
|
Basic Admin Protocols