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 |
|
pras2007
Posting Yak Master
216 Posts |
 Posted - 2009-07-31 : 07:53:36
|
| Hello All,I just starting working for this organization as a DBA and everything is going perfect, actually too perfect! My question is what should I check for on my SQL Server 2005 environment to alert me of any hidden problems that can occur later... Meaning what should I check for on a day to day operation (normal routine checks)? Please advice. Thanks. |
|
|
wshawnmelton
Starting Member
17 Posts |
Posted - 2009-07-31 : 09:00:10
|
| Congrats on getting a DBA position. The main thing is just going through the Window and SQL logs. You can find articles on Google about what errors to pay attention to or even to setup alerts for. There are other task you may do but it would be dependent on your environment and database configurations.I would suggest you search Google on that subject to get you started. I have found this book to be very useful: "Administrator's Guide to SQL Server 2005" by Buck Woody.w s melton |
 |
|
|
|
|
|
What should I check for on a day to day basis?